How to calculate measures for the Previous month

[Suchitra-15]

Hi,

I have measure name column in my dataset. 

That column contains different measure names such as Revenue, PBIT, Gross profit, net profit, COGS, Total cost, account payable, account receivable etc. Then I want to find out values for this measures for the previous month.

Than please provide me how to do that?

[Aditya_Chitale]

Try using this set analysis expression:

sum({<Month={"=$(Date(Addmonths(max(Date),-1),'MMM-YY'))"}>}MeasureName)

Try playing with date & month as per your data.

Regards,

Aditya

[Suchitra-15]

Thank you Aditya,

Expression is correct but does not shows values

This is expression: sum({<Date={"=$(Date(Addmonths(max(Date),-1)))"}>}[Measure Name]='Revenue')

Please check it and get back to me

Regards,

Suchitra

[Aditya_Chitale]

Did you try changing date format ? I cannot help you much unless I see your data. If possible jumble values and share sample data.

Regards,

Aditya