Skip to main content

SELECTEDVALUE option in automatic aggregations


Add a new "Selected Value" option to the field wells and default aggregations that reproduces the behavior of a SELECTEDVALUE measure in DAX. (Returns the value when the column, as filtered, has one distinct value. Otherwise, the field is empty.)


This would be extremely powerf...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
New

Alternate operators to make 1 + BLANK = BLANK


To streamline error handling, create operators or a wrapper function to force BLANKs to propagate through addition & subtraction as they do multiplication/division. Error-tolerant functions like DIVIDE are extremely helpful in creating measures, but addition & subtraction outside these functio...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
New

Create an optional "Ignore If Not Found" argument and optional "Use Wildcards" argument in M functions Table.TransformColumns and Table.TransformColumnNames to make dynamic transformations intuitive


In the funtions Table.TranformColumns and Table.TransformColumnNames that take a list of column names as an argument:

Optionally ignore column names not found rather than erroring and optionally use wildcards * and ? in column names.

(Natively in the functions.)


Ta...

Read more...
0 Comments

Read more...
0 Comments

STATUS DETAILS
New