Forum Discussion
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...
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 Thanks for your immediate solution. Works perfectly! Thank you so much for your help.