Forum Discussion
Variances between multiple columns and return lowest value
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
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.
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
- Zubair_Muhammad
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 ColumnMinValue = MIN ( MIN ( MIN ( TableName[VENDOR 1], TableName[VENDOR 2] ), TableName[VENDOR 3] ), TableName[VENDOR 4] )