% change column MoM

[RichOB]

Hi, I want a column that shows the % change month over month. I have the Incident Count that month, the Previous Incidents Count, and the difference in 3 separate measures. For some reason I'm struggling to get the % growth difference. What calculation would show:

May = 4.7% change from April

June = -1.98% change from May

July = 23% change from June

August = -32% change from July

And so on

Thanks

[v-bmanikante]

Hi @RichOB ,

Thank you for reaching out to Microsoft Fabric Community Forum.

@DataNinja777  Thank you for you prompt response.

I’ve attached a sample Power BI (.pbix) file for your reference that includes the MoM% (Month-over-Month Percentage) measure based on your layout.

mom_revised = var prev=SUM(Mom_Data[Prev])

var cur=SUM(Mom_Data[Incidents])

RETURN

    cur-prev

MOM% = DIVIDE(Mom_Data[mom_revised],SUM(Mom_Data[Prev]),0)

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,
B Manikanteswara Reddy

[DataNinja777]

Hi @RichOB ,

To calculate the Month-over-Month % Change based on the difference between the current month's incidents and the previous month's incidents, you can use a DAX measure like this:

MoM % Change = 
DIVIDE([Mom1], [Prev])

This formula divides the difference in incidents ([Mom1], which is [Incidents] - [Prev]) by the previous month's value ([Prev]) to get the percentage change. Be sure to format this measure as a percentage in the Power BI Modeling tab so that the output appears correctly (e.g., 4.7% instead of 0.047). If the numbers still seem off, double-check that your [Prev] measure is returning the correct prior month’s incident count. If needed, I can help verify or adjust the [Prev] logic.

Best regards,

[RichOB · Accepted solution]

Hi @DataNinja777 thanks for your reply. Your solution gave me the correct percents but the ones that should be a minus were a positive and vice versa. For example, May is showing as 4.52% but it should be -4.52%, and June should be 2.03% not -2.03%. Why would this be please?

[ryan_mayu]

@RichOB 

you can try this

DIVIDE([incident],[Prev]) -1