Monthly Sales Growth measure

[gbarr12345]

Hi,

I'm trying to create a measure to show the month sales growth but when I ran the measure and put it into the graph the growth is showing -100% as per the screenshot.

I have the code below. Any help to fix would be appreciated!

Thank you 🙂 

Monthly Sales Growth =

DIVIDE([Total Sales],

CALCULATE([Total Sales], DATEADD(Orders[Order Date], -1, MONTH) ), 0) -1

[PijushRoy]

HI @gbarr12345 

For the Time Intelligence function, please use the Calendar table and use the Calendar table as the Date Table
Ref - https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables

You are using Month in your DAX measure to calculate Last Month sale
But you are using Date as Row Header.
Please use Month as Row Header

Share a sample PBIX file link (Google Ddirve/Sharepoint/Dropbox) to get a more accurate answer if not solve your question

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[gbarr12345]

Hi Pijush,

I've attached my Google drive with the PBIX file now.

Hopefully you can help me fix it.

Many Thanks.

https://drive.google.com/file/d/1cl5RN3MHqMEFbAtQ4_PtOwz0-oV_5Hba/view?usp=drive_link

Hope you can help me solve it.

Many thanks.