2 column headers - Variance Between This Year and Last Year UNDER Day of the Week

Daniel Simpson · September 14, 2021 10:54

I'm curious as to how a measure is inserted for ((TY vs LY) -1) for each day of the week as below:

0

Comments

1 comment

Sort by Date Votes

Daniel Simpson September 15, 2021 10:10
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.
0

Please sign in to leave a comment.