How to make a Percentage Change Column in Matrix Table

[derekli1700]

Hi - I would like to make a YOY percentage change column in my matrix table. 
Heres my sample dataset:

Category	Customer	Application Date
A	NexSys Solutions	1/12/2024
A	CloudBridge Innovations	2/2/2021
B	Cognify Analytics	3/7/2021
B	PrecisionMek Engineering	4/7/2022
A	Titanium Dynamics	6/10/2021
C	Capstone Advisors	6/4/2023
B	BlueChip Financials	4/12/2022
C	PrimeVest Partners	5/12/2024
C	TransWorld Freight	4/12/2023

My current matrix table is seen below - i basically want to make a percentage change column for A, B and C to show the x% decreased or increased from last year and if we drill down to months, it will also show the percentage change for that as well. Thanks

[webster12]

new learnings thank u boss 🙂

[danextian]

Please mark my post as solution if you post has been resolved based on your initital requirements.

[danextian · Accepted solution]

Hi @derekli1700 

Make sure to use a separate dates table and mark it as a date table

Create a one-to-many single direction relationship

Create this measure

Delta = 
VAR PrevYear =
    CALCULATE ( [Count], SAMEPERIODLASTYEAR ( CalendarTable[Date] ) )
VAR Difference = [Count] - PrevYear
RETURN
    DIVIDE ( Difference, PrevYear )

Please see attached sample pbix