UPPER

In the Ultra Transcenders books

DBX-DEP

Each book explains UPPER in context, with comparison tables and the common traps.

Terms in this definition

• ALL

  A DAX function that ignores any filters and gives back every row of a table or every value of the named columns. Used within CALCULATE, it works as a modifier that clears filters, although REMOVEFILTERS states that intent more clearly where it is available.

Related terms

• Degree of copy parallelism

  The upper limit on simultaneous read or write threads in a Copy activity, configured separately from intelligent throughput optimisation. With partitioning in use it governs how many partition queries run together, so a value that is too large risks overwhelming the source system.

• Dynamic range partition

  Parallel reading for the Copy activity, achieved by carving an integer or date/datetime column into slices and running one query per slice. The upper and lower values only decide slice width, never which rows are copied, and hand-written SQL needs the ?DfDynamicRangePartitionCondition placeholder.

• Power Fx

  Low-code formula language, similar to Excel, used in Foundry workflows. Each variable takes a Local. or System. scope prefix; IsBlank checks a value, IsEmpty checks a table and Upper() converts text to capitals.