Forum Discussion
Helper IIIHow 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 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
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
3 Replies
- danextian
Super User
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
new learnings thank u boss 🙂
- danextian
Please mark my post as solution if you post has been resolved based on your initital requirements.
