Skip to Content
0
Former Member
Jul 06, 2015 at 12:54 PM

RelativeValue () for last year Indicator.

222 Views

Hi Masters,

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

Attachments

Table.jpg (48.6 kB)