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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
aausten22
Helper I
Helper I

Calculating Percentage Change

Hi There, 

 

I know this is often asked on the forum though nothing I have found works with what I am wanting to achieve

 

Currently there is a measure to count how many of each type of correspondence there is depending on the group that is chosen in the slicer. I also have a date slicer choosing which month I want to look at

 

Now I am wanting to use the measure (count the correspondence for selected month / count of correspondence for previous month ) / count of correspondence for previous month

 

This will then go into an IF ELSE statement so that if the number is a positive then  the word Positive would show, else Negative


Type        EOM      Group

AdviceJun-23ABC
GeneralJun-23GFH
GeneralJun-23GFH
GeneralJun-23STU
AdviceJun-23DFG
WrittenJun-23HJK
1 ACCEPTED SOLUTION

3 REPLIES 3
VilmarSch
Post Patron
Post Patron

Veja se o PBIX aqui ajuda

 

MKiChyobMq.gif

Hi There, 

 

This link came up with an error, can you please send it again

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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