Creating conditional columns on a matrix

[Anonymous]

Hello, 

I have the following table, where all 3 columns are created using a measure.

I have managed to create the Variance measure as it was easy ---> Measure for Column 2 - Measure for Column 1 

However, I am not sure how to create these two extra columns with values for each row:

• Churn = if Column 1 - Column 2 > 2,500 then that value otherwise 0
• New = if Column 2 - Column 1 > 2,500 then that value otherwise 0
  

The 2,500 is a constant comparison (it doesn't change). 

Many thanks! 

Soo

[Greg_Deckler · Accepted solution]

@Anonymous Unless I am missing something this should just be:

Churn Measure = 
  VAR __Churn = [Measure for Column 1] - [Measure for Column 2]
RETURN
  IF(__Churn > 2500,__Churn,0)



New Measure = 
  VAR __New = [Measure for Column 2] - [Measure for Column 1]
RETURN
  IF(__New > 2500,__New ,0)