Forum Discussion
How to compare two columns
I have two columns in my matrix, Sales_price and Total_value. I want to compare the two columns and generate a 3rd column. The 3rd column will have values based on the comparison on the 2 columns. If...
I tried your formula but now when the Total values is more than sales value its adding the 2 values together.
Here are my formulas
MAXSALESVALUE = MAX(Query1[Sales_price])
SumOfTotalValue = CALCULATE(SUM(Query1[Total_value]),ALLSELECTED(Query1[WORK_ORDER_NUMBER]) )
WIPMAX_T = SUMX (FILTER ( VALUES ( Query1[WOROOT] ), [SumOfTotalValue] > [MAXSALESVALUE] ),[MAXSALESVALUE])+SumOfTotalValue]
when the total value is less than sales price then it is fine.
v-huizhn-msft Any idea where i am going wrong