I need to create a scenario like this table
We analyze the data by quarter for past years and by month for current years, its controlled by the formula :
=If ToNumber([Natural Year])=Year(CurrentDate()) Then [Month] Else [Quarter]
The problem is with the measure that is getting an evolution comparing current year with last year.
As we get the last year value with the function: RelativeValue([Var];([Natural Year]);-1), and we analyze with different dimension depending the year, I guess the table cannot calculate it.
Do you know any other way to build the table to get quarters or moths depending of the year that I could use relativeValue()?
Thank you by advance