Forum Discussion
Calculating Variance: Multiple Years on a table
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.
Whatever two years that the user chooses; I want there to be a variance Column that shows what the pecentage between those years are on the table.
If there is an easier solution to show the variance, other than a table, I'm willing to try it.
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.