Forum Discussion

ephramz's avatar
ephramz
Icon for Helper II rankHelper II
5 years ago
Solved

Dax Function to compare two column from same table

How do I create a new measure table to compare and retrieve the higher value and divide this value with quantity.   The result column is what I want my "measure" to be able to do. The data are all ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    ephramz , Create a new measure like

     

    sumx(table, divide( if([Time1]>[Time2], [Time1], [Time2]),[Quantity]) )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

ephramz , Create a new measure like

 

sumx(table, divide( if([Time1]>[Time2], [Time1], [Time2]),[Quantity]) )