This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
Hello,
I really stuck on something really basic. I just want to be able to add somwthing to this Matrix that shows the difference between the 2 months. I have searched the internet and forums but I can't seem to find anything.
Here is my basic Matrix that I am building so you can see my structure.
Everything is from one Data Source Table called TPL Test Pet
Really hoping someone can help.
Regards
Gavin
I would suggest having a look at this:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
You should be able to engineer measures that display your information in the rows as they are now but in the Total area show the difference.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 45 | |
| 38 | |
| 24 | |
| 22 | |
| 20 |