Forum Discussion
Problem with Moving Annual Total
Hello, I created several Columns in my Date-Table wich indicate dynamically if a date belongs to a certain period. This is important, because I do not want to change the filtering conditions all ...
Thanks for your answer, but the result is the same as I totally omit the all-Filter.
The problem is actually this one:
I want to produce a visual with a moving annual total for each month. So, in January I want to see on the visuale a stacked column with the different productsubcategories for the range from Dec 14 - Dec 15, as well as from Nov 14 - Nov 15, and so on. Is there any possibility to do a visual like that?
Thanks for you help.
itchyeyeballs
Impactful Individual
Impactful IndividualYou could use the year to date function rather than calculate - https://msdn.microsoft.com/en-us/library/ee634400.aspx
you should just need one new column in your date table which has the end of the month date to pass to the function.You can calculate that using