Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hi All
Hope someone can assist. I have a Matrix which will only ever have current and previous years data. Columns are Year and Month whilst rows are Products. I need to add a Variance column (variance between the two Totals) at the end of the Matrix but as a newbie, I just cant figure it out.
I hope I've added enough detail. Thanking in advance
Cheers - Grant
@Grant_Reid, check out this article by @Greg_Deckler:
Proud to be a Super User!
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 22 | |
| 21 | |
| 20 | |
| 19 | |
| 13 |
| User | Count |
|---|---|
| 58 | |
| 50 | |
| 38 | |
| 31 | |
| 27 |