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
Hi Ashish,
Thank you for your speedy reply.
So to begin with I have some other challenges, which i think actually stems from the structure of the original data table.
In the visual when I use the details of the model, region, Qty sold (which exists in one datatable) If I try to drag pricing into the same table us select price for example it shows a blank value.
All the tables have a relationship to the sales data table through the primary key, or could be linked through the model number itself.
I did as you advised, which was to unpivot other columns. Regardless, I still can't get the prices even to reflect against the models from a different dataset.
Are you able to advise on this?
Thank you so much
Hi,
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.
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 ColumnMinValue = MIN ( MIN ( MIN ( TableName[VENDOR 1], TableName[VENDOR 2] ), TableName[VENDOR 3] ), TableName[VENDOR 4] )