Forum Discussion
Variances between multiple columns and return lowest value
Hi There, I am seeking some support for a DAX expressions which will measure variance between 4 - 5 columns on a data table and return the lowest value. For example mODEL | REGION | CURRENT ...
Anonymous
With Query Editor, it is much easier to add a Minimum Value Column
Select all the Vendor Columns>>> Go to "Add Column" Tab>>> Statistics >>>Minimum
Anonymous
With Query Editor, it is much easier to add a Minimum Value Column
Select all the Vendor Columns>>> Go to "Add Column" Tab>>> Statistics >>>Minimum
Anonymous
If you want to use DAX and do not want to unpivot and have few VENDORS like 4-5 to compare....
then you can also use following calculated Column
MinValue =
MIN (
MIN ( MIN ( TableName[VENDOR 1], TableName[VENDOR 2] ), TableName[VENDOR 3] ),
TableName[VENDOR 4]
)