cancel
Showing results for 
Search instead for 
Did you mean: 

Obtain the measure value from previous month

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

IngoH
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

hi Juan,

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

Regards

Ingo

BKE
Explorer
0 Kudos

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
0 Kudos

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
0 Kudos

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.

Answers (0)