percentage change from month to month

[netanel]

Hello everyone!
quick question
Is there a convenient way to calculate the percentage change in a single value?

I have a graph that creates a month-to-month comparison based on years
I want to calculate the percentage change from month to month

Familiar?

[ALLUREAN · Accepted solution]

Hi, @netanel 

You can try something like:

MoM% Measure =
VAR PREV_MONTH = CALCULATE(SUM('P&L'[Values]), DATEADD('Date'[Date], -1, MONTH)

//Replace 'Date'[Date] by your date column coming from Calendar table

VAR CURR_MONTH = SUM('P&L'[Values]) --Selected by slicer
RETURN
DIVIDE(CURR_MONTH - PREV_MONTH, PREV_MONTH )

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/