Advance calculated Metric

Ok this is actually a really creative way to do comps! The caveat with this is that you have to put it against the month dimension in order for it to calculate the MoM, since the cumulative relies on the rows.

That being said, if you want YoY instead of MoM, but for a specific month, you would need to have 13 months in your table (TY’s month and all the way back to the YoY month). Then for your cumulative, instead of 2 and 1 for the numbers, you would use 13 and 12. So that would go back 13 rows to the same month last year, and then for that month TY, it would show you the comp value.

However, you’re going to end up with a lot of rows in your table that don’t return any value at all because of how it works, unless you use “display only selected rows”. Fortunately, because the functions work a bit funky this will still work for what you need. But you still need to have the longer time period either as your panel date range or as a date range in your table.