Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
The 2,500 is a constant comparison (it doesn't change).
Many thanks!
Soo
Solved! Go to 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)
@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)