Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Look up min and max values

Hi    Im pretty new to POwer Bi and am having trouble getting this simple DAX to work, please help!   I have a table of customer rates for different tariffs: Customer Tariff Type Rate AB...
Need Help
gpoggi's avatar
gpoggi
Icon for Responsive Resident rankResponsive Resident
7 years ago

Hi Anonymous ,

 

In fact, you don't need a DAX formula, you can get it by drag and drop Tariff Type to the table visualization and then drag and drop Rate column two times, and then just click in the rigth arrow:

 

Then just select Minimum operation for first Rate, and the Maximum operation for the second Rate:

 

 

and that's it you will get your desired table:

 

 

Hope this helps,

 

 

Regards,

 

Gian Carlo Poggi

 

 

 

 

JosefPrakljacic's avatar
JosefPrakljacic
Icon for Solution Sage rankSolution Sage
7 years ago

Yes you are right gpoggi sometimes dax would be an overkill if you just want a simple table visual :-P