cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Analitika
Post Prodigy
Post Prodigy

Calculate sales growth in euros and percentage in Power BI

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?

2 REPLIES 2
danextian
Super User
Super User

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:

danextian_0-1687242322856.png

 


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






Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Connect to me on LinkedIn || Need consulting? Hire me for a Power BI gig on UpWork.
Learn with me on YouTube @PowerBITambayan.

why 

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

Not reverse. sales measure - sale previous month.

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors