Rolling 12-Months Sum and Average starting and ending period
I'm calculating rolling 12-months sum and average and have problems with starting and ending periods. I was able to get right numbers for the most of the part but what I need is to get rid of the first 11 months and ending the calculation to current period.
And get the result below. So when I use that Year/month dimension in a chart I would like to see only time period 2017.12-2019.10 so that it calculates 2017.01-2017.12 for the period 2017.12 and the last period should be current month. I have a variable vL_current_period I hope I can use here but I just don't know how. Do you have any suggestions? Thank you!