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.

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

Hi,

Anonymise the data and share it from your Home.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    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.