Hello,
I am constructing a report based on Measures in an Azure Analaysis Services database.
I would like this report to report on monthly data for three time periods (in the same report, preferably in the same visuals as well). The periods are as the following:
1. The last month (e.g. 1. - 31. January)
2. The last n months (n is often 6 months, but the user should be able to change this)(August 2020, September 2020, October 2020, November 2020, December 2020, January 2021)
3. The last N months (a time period longer than n months, for example the last 13 months)
That is; time periods 1., 2. and 3. all end in the same month (here January 2021). 2. goes n months back in time, and 3. goes N>n months back in time.
On some pages, I will only use data from one period, in others I will mix them. I want to be able to make visuals where I compare means from the three time periods in a bar chart e.g.
I have tried to use 3 slicers and Edit interactions so that they don't interact. However, I feel that this is a brute force method that is bound to fail. I have also tried to write som DAX code for it. This only works for cases when the length of the time periods is given on beforehand - I want the user to be able to change the length of time periods 2. and 3.
