Dax Function to compare two column from same table

Question

How do I create a new measure table to compare and retrieve the higher value and divide this value with quantity.&nbsp;The result column is what I want my "measure" to be able to do. The data are all in the same table.Eg:&nbsp;&nbsp;Time&nbsp; &nbsp; &nbsp;Time&nbsp; &nbsp; &nbsp; &nbsp;Actual Time (Higher value)&nbsp; &nbsp; &nbsp; &nbsp;Quantiy&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Result50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2530&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10

amitchandak · Accepted Answer

ephramz , Create a new measure like
&nbsp;
sumx(table, divide( if([Time1]&gt;[Time2], [Time1], [Time2]),[Quantity]) )

Forum Discussion

Dax Function to compare two column from same table

1 Reply

Related content

Hash Function for Row Compare

Compare Dynamic Columns in a Matrix

Today Function in Column

Comparing columns error

Using TREATAS DAX function in calculated columns