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
Ashish_Mathur
Super User
Super UserHi,
The question in your most recent reply is different from the one you posted initially. In the initial post, you just had one Table but in your most recent post, you have more than 1 Table.
Please share the link from where i can download your PBI file and also show the expected result there.
Zubair_Muhammad
Community Champion
Community ChampionAnonymous
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