Forum Discussion

RichOB's avatar
RichOB
Post Partisan
1 year ago
Solved

% change column MoM

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

Need Help
  • RichOB's avatar
    RichOB
    1 year ago

    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?

     

4 Replies

  • DataNinja777's avatar
    DataNinja777
    Super User
    1 year ago

    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's avatar
      RichOB
      Post Partisan
      1 year ago

      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?

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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