Forum Discussion
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 ...
ephramz , Create a new measure like
sumx(table, divide( if([Time1]>[Time2], [Time1], [Time2]),[Quantity]) )
ephramz , Create a new measure like
sumx(table, divide( if([Time1]>[Time2], [Time1], [Time2]),[Quantity]) )