Forum Discussion

alau's avatar
alau
Icon for Helper I rankHelper I
3 years ago
Solved

Data transformation help - Unpivot selected rows to columns

Hi BI experts out there, any help will be appreciated.   I have been struggling with this data transformation for the past couple of hours!   I want BI to maintain the first 4 columns (green), an...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You may download my solution PBI file from here.

    Hope this helps.

alau's avatar
alau
Icon for Helper I rankHelper I
3 years ago

Absolutely amazing! Thank you so much Ashish_Mathur for your brillant solution!

I will now try your steps with a bigger pool of data, and hopefully I can follow your logic if I were to hit any hurdles with the larger sample. 

 

I can't say i fully understand the logic of the group and ungrouping yet, but I will be sure to study it to learn from your steps.

 

Many thanks to you and this wonderful BI community! 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

You are welcome.