Forum Discussion

RichOB's avatar
RichOB
Post Partisan
1 year ago
Solved

Percent difference between 2 measures

Hi, my mind has gone blank with this one. How do I get the % difference between the measures ac23 and ac24? April should be a 0.71% increase.

 

 

Thanks

Need Help

3 Replies

  • pankajnamekar25's avatar
    pankajnamekar25
    Super User
    1 year ago

    Hello RichOB 

     

    try this measure

     

    % Increase from ac23 to ac24 =

    DIVIDE([ac24] - [ac23], [ac23])

     

    Thanks,
     Pankaj Namekar | LinkedIn

    If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

    • RichOB's avatar
      RichOB
      Post Partisan
      1 year ago

      This is great thank you!

    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      1 year ago

      Hi RichOB 

      If the answer posted by pankajnamekar25 is helpful, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post. If you are still facing any issue, please let us know in the comments. We are glad to help you.

      We value your feedback, and it will help us to assist others who might have a similar query.
      Thank you for your contribution in enhancing Microsoft Fabric Community Forum.