Forum Discussion
derekli1700
1 year agoHelper III
How to make a Percentage Change Column in Matrix Table
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 In...
- 1 year ago
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