SAP Analytics Cloud Calculated measure in the model of previous year not working properly

[michal31975]

Hi,

I'm facing the issue when I'm trying to create a calculate measure in my planning model. I would like to present an amount of the previous year in all my stories, but also divided properly for quaters and months. This is the formula I wrote:

And this is the result:

So as you can see, it returns the amount for the whole year also in quaters and months.

I tried also this formula, but the result is the same:

It works properly with restricted measure if I create it in story, so I wonder what can cause the issue and what should I change in my formula to have it working properly??

[Yogeshwar_Mali]

Hii Sir,

Lookup not show's Hierarchy level values it's for different uses.

Previous year requires Date to be drilled to the lowest hierarchy level.

Try to Restrict formula it shows all Hierarchy level values in cell.