Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register 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? 😞
| User | Count |
|---|---|
| 57 | |
| 44 | |
| 32 | |
| 16 | |
| 14 |
| User | Count |
|---|---|
| 82 | |
| 66 | |
| 42 | |
| 27 | |
| 25 |