Forum Discussion

SirJJAnderson's avatar
SirJJAnderson
Icon for Helper III rankHelper III
6 years ago
Solved

How to Calculate MoM Percentage Change?

I tried following a solution I found online and it isn't quite working. I was able to create a column that shows the prior month's data, but I can't figure out how to then calculate the percentage ch...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    You can try this approach.

     

    Pct Change MOM = var thismonth = sum('Table1'[Deliveries])

    var lastmonth = [Deliveries MOM] //your existing measure

    return divide((thismonth-lastmonth), lastmonth)

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

  • amitchandak's avatar
    amitchandak
    6 years ago

    SirJJAnderson , Try like

    chnage % = DIVIDE((SUM(Table1[Deliveries]) - [Deliveries MOM]), [Deliveries MOM])

     

    And Mark it as % column

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

You can try this approach.

 

Pct Change MOM = var thismonth = sum('Table1'[Deliveries])

var lastmonth = [Deliveries MOM] //your existing measure

return divide((thismonth-lastmonth), lastmonth)

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

  • SirJJAnderson's avatar
    SirJJAnderson
    Icon for Helper III rankHelper III
    6 years ago

    So this formula worked, but technically is not correct. You're right about needing to subtract Deliveries MOM from Table1[Deliveries] before I do the divide.

     

    Delivery % Change = DIVIDE(SUM(Table1[Deliveries]), [Deliveries MOM])
     
    How would I adjust this formula to do that? Something like the below? The below doesn't throw an error but the result is wrong.
     
    Delivery % Change = DIVIDE((SUM(Table1[Deliveries]) + [Deliveries MOM]), [Deliveries MOM])
    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      6 years ago

      SirJJAnderson , Try like

      chnage % = DIVIDE((SUM(Table1[Deliveries]) - [Deliveries MOM]), [Deliveries MOM])

       

      And Mark it as % column