Forum Discussion
Need Help on a table
Hi Theeshk93
In the query editor, you can unpivot all columns and then remove blank rows from the resulting value column and then add an index or order column for each unique department per manager either with DAX or M. You can use this order column to create a kind of invisible key so provide a row context for each department per manager so all
Please refer to the attached pbix for the details.
Hi Theeshk93,
Hi,
I wanted to check in your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply as Accepted solution and give Kudos that helped you. It would be greatly appreciated by others in the community who may have the same question.
Thann you,
Sahasra.
Hi Sahasra,
My problem is not solved yet, I have responded above.TIA
