Forum Discussion
Unpivot/Pivotting Table
Hi All need assistance with pivotting/unpivotting a table via powerbi desktop i have date output in powerbi similar to this structure below i have unpivoted other columns when ...
Anonymous , After the unpivot, Create a new column with value: Only Date and Product and Pivot it.
One example
Type = Text.Start([Attribute],4)
Also check if needed
https://kohera.be/blog/power-bi/how-to-unpivot-twice/
thanks amitchandak
when i follow the document and your scenario i get errors
when i pivot table, i am highlighting just the new custom column (which has Date and Prod) and i pivot on that. ensuring "Dont aggregate" is set in advance options
from there i have the right structure but the cells in both Date and Prod have an errorive blanked out the name but what am i missing?
could it be that due to the Value column has multiple values that are the same? then do i need add an index of sorts?