Forum Discussion

Fabrizio's avatar
Fabrizio
Regular Visitor
4 years ago
Solved

complication with depivotizing

Hi   I have a planning list, that look like the following.  To use it as monthly planning values, i can just depivotize it in power query and use it perfectly.    There is one line per Int...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Fabrizio , Take the first 10 columns in the second one and unpivot the columns one to 8

     

    Remove first 8 and unpivot the month in another table.

     

    merge the two -  internal order number from the second table and the unpivoted order number using left join (second to first)

     

    Now you can multiple Percent with number

     

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

amitchandak's avatar
amitchandak
Super User
4 years ago

Fabrizio , Take the first 10 columns in the second one and unpivot the columns one to 8

 

Remove first 8 and unpivot the month in another table.

 

merge the two -  internal order number from the second table and the unpivoted order number using left join (second to first)

 

Now you can multiple Percent with number

 

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.