2 column headers - Variance Between This Year and Last Year UNDER Day of the Week
I'm curious as to how a measure is inserted for ((TY vs LY) -1) for each day of the week as below:
0
I'm curious as to how a measure is inserted for ((TY vs LY) -1) for each day of the week as below:
Comments
Solution:
if sum(0, 0, m1) = 0 then 0 else if sum(1, 0, m1) = 0 then 0 else (sum(0, 0, m1) / sum(1, 0, m1)) - 1
I was unaware the delimiter could be numerical other than zero. Now I know.
Note: This solution creates a 'Var %' measure for each field. Just use the visibility setting to hide the unwanted measure columns.
Please sign in to leave a comment.