Forum Discussion
Calculating Variance: Multiple Years on a table
Hi, I am wanting to show the variance in this table between the different years (Compare 2016 to 2015 and 2015 to 2014. I am unsure how to achieve this result. Any advice?
In order for the user to control 2 different dates, it's probably best to have 2 different date tables. (I could imagine also using a single table and using MIN / MAX to choose the years, but that feels weird to me).
Then you are sorta doing "sales, as filtered by date table 1" and "sales, as filtered by date table 2", then another measure to compare those.
We are going to need more info. For starters - do you have a separate date table, connected to your raw data by date?
At any rate, you will find useful patterns on Period Comparisons here:
http://www.daxpatterns.com/time-patterns/