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...
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)
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)