Calculate sales growth in euros and percentage in Power BI

[Analitika]

Hi.

I need calculate the growh sales in euros and percentage comparing with previous month. I have measure which calculate sales. [sales]. So how implement my case?

[danextian]

Hi @Analitika ,

How does your data model look? Are you using a separates Dates table? If so, try these:

Sale Previous Month =
CALCULATE ( [sales measure], PREVIOUSMONTH ( datestable[date] ) )

Growth in Euro =
[Sales Previous Month] - [sales measure]

Growth % =
DIVIDE ( [Growth in Euro], [Sales Previous Month] )

If this doesn't work, please provide sample data (not an image). Here's how you can get a better response

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/144... 

Also, please try searching for related posts:

Please provide sample data as well (not an image). 

[Analitika]

why 

Growth in Euro =
[Sales Previous Month] - [sales measure]

Not reverse. sales measure - sale previous month.