Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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