Forum Discussion

amulyasai's avatar
amulyasai
New Member
8 years ago

Monthly Percentage Formula not working

Hello,

I am using the below formula to calculate monthly percentage change for the chosen month and the previous month.

Reach % Chg. = (format((sum(fbAdData[Reach])-[Reach Prev. Month])/[Reach Prev. Month],"+0%;-0%;0%"))

This formula was working when both the months were from same year, but its throwing an Inf error when I choose Jan 2018 as my current month. Is there anything wrong with formula? Any help where this is going wrong? 

2 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi amulyasai,

    You need to share the formula of measure [Reach Prev. Month] and your .pbix to troubleshoot.

    Best Regards,
    Angelia

    • amulyasai's avatar
      amulyasai
      New Member
      8 years ago

      Hello Angelia,

      The formula I'm using is 

      Reach % Chg. = (format((sum('test data'[Reach])-'test data'[Reach Prev Month])/'test data'[Reach Prev Month],"+0%;-0%;0%"))

       

      Power BI file and excel file is in the below wetransfer link

      https://we.tl/8OxAMyE8Ut

       

      Please let me know if you need anything else.

       

      Looking forward to your response.

       

      Thanks,
      Amulya