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 nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
I am building a profit and loss in PowerBI and I'm using a book and youtube tutorials from datatraining.io.
I have a financial statement structure that contains 2 levels.
Like this:
I have individual measures calculating the level 1 items.
Now I want to create a matrix with in the rows the level 1 and level 2. The column months.
And the values are the realisation of the rows per month.
I copied a measure from the book, but in the book there is only one level. So I understand that I need to do something to check if it is a level 1 or level 2 item, and then switch. Right now with this measure the level 1 row is empty and all the level 2 values are shown.
No one? 😞
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 |
|---|---|
| 24 | |
| 22 | |
| 22 | |
| 20 | |
| 12 |
| User | Count |
|---|---|
| 68 | |
| 56 | |
| 42 | |
| 39 | |
| 30 |