Forum Discussion
Creating conditional columns on a matrix
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
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)
1 Reply
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)