Obtain the measure value from previous month

[Former Member]

Hello everybody, I have a doubt.

Is there any way to obtain values from previous months using the SAP Analytics Cloud?

I need to make a comparison between current month and previous 6 months values.

Thanks for any advice that can provide me.

Regards.

[IngoH · Accepted solution]

Hello Juan,

did you look at the options to create calculated measures ?

You could create a measure for the last month and one for the 6 month period.

Perhaps you can share some more details on your data and what you would like to achieve and I am sure we can come up with a solution.

Regards

Ingo Hilgefort, SAP

[Former Member · Accepted solution]

Hi Ingo, thank you very much for your answer.

In my case, I'm trying to show values for example from the current date in a column, and in another column values from the previous six months, taking the values from the current date like main values.

The data comes from SQL Server 2014. And the models are based from SQL databases.

How can I achive the measures that you spoke to me?

Thanks.

[IngoH · Accepted solution]

hi Juan,

you should be able to create calculated measures in the story.

Regards

Ingo

[BKE · Accepted solution]

Hi Juan,

You need to create a restricted key figure with a fixed value for the calendar month of the last month.

Then add this key figure into your report.

Hope that helps.

BK

[Former Member · Accepted solution]

Hi BK,

Thanks for your answer. How can I created a key figure and configure the calendar month. In my case the sql server view only have month and year values.

Thank you very much for the help.

Regards.

[Former Member · Accepted solution]

Hello everyone,

Finally I achieved my goal showing the current values and the 6 previous months values. I followed your indications but it is neccesary know the formulas that can be processed in the model.I'm going to attach the SAP link

Formulas

Regards.