Forum Discussion

Prabha45's avatar
Prabha45
Helper III
2 years ago
Solved

Data model - Unpivot

Hi All, I have a table(data model) like the below. For every quarter there will be 2 new columns( Status and comments). I tried unpivot the Q3, Q4 status in one table and in the other by Q3, Q4 c...
Need Help
Show and Tell
Tips and Tricks
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

     

Ahmedx's avatar
Ahmedx
Super User
2 years ago

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

 

Prabha45's avatar
Prabha45
Helper III
2 years ago

Thank you very much. Can you please explain the grouped rows step