Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
RichOB
Post Patron
Post Patron

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.

 

ac44.png

 

Thanks

1 ACCEPTED SOLUTION
pankajnamekar25
Memorable Member
Memorable Member

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.

View solution in original post

3 REPLIES 3
pankajnamekar25
Memorable Member
Memorable Member

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.

This is great thank you!

Hi @RichOB 

If the answer posted by @pankajnamekar25 is helpful, please accept the answer by clicking the "Upvote" and "Accept Answeron 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.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.