Forum Discussion

Theeshk93's avatar
Theeshk93
Frequent Visitor
1 year ago
Solved

Need Help on a table

Hi, It will be much appreaciated if someone can help in the below query please. Problem - I'm creating a table with the names of managers and the departments they are incharge of. My source tab...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    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.

     

danextian's avatar
danextian
Super User
1 year ago

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.