Skip to Content

Obtain the measure value from previous month

Mar 28 at 07:43 AM


avatar image

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.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Ingo Hilgefort
Mar 28 at 07:56 PM

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.


Ingo Hilgefort, SAP

Show 5 Share
10 |10000 characters needed characters left characters exceeded

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?



hi Juan,

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




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




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.



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.