Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table which contains a period field in the form (day / month / year) where the period is always brought back to the first of the month, like this: 01/02/2020 for the first February 2020.
And digital data fields.
I would like to display the value of each month (12 months rolling ) on a graph of the curve when I select a given period.
Can someone help me?
Thank you
I found !
avg({1<PERIODE = {">=$(=MonthStart(Max(PERIODE), -11))<=$(=MonthEnd(Max(PERIODE)))"}>}VALUE)
With PERIODE in Dimension and this in measure expression : avg({1<PERIODE = {">=$(=MonthStart(Max(PERIODE), -11))<=$(=MonthEnd(Max(PERIODE)))"}>}VALUE)