Calculating Percentage Change

[aausten22]

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

Advice	Jun-23	ABC
General	Jun-23	GFH
General	Jun-23	GFH
General	Jun-23	STU
Advice	Jun-23	DFG
Written	Jun-23	HJK

[VilmarSch]

Veja se o PBIX aqui ajuda

[aausten22]

Hi There, 

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

[VilmarSch · Accepted solution]

PBIX aqui