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...
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...
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...