Forum Discussion
transpose vertical column to horizontal
Hi, I want to transpose a vertical column to horizontal, but problem is that vertical column is calculated and I have more than one company and product. Sample data and result is like following. ...
Inside 'Transform Data' you want to look for the options "Pivot Column" or "Unpivot Columns". In your case it seems you wish to unpivot columns. In this case you would click the drop down arrow and select "Unpivot Other Columns" to keep your solution data driven.
Hi,
The remainder column is calculated, not in Power Query. And I have more than one company and product. Pivot doesn't work here
Do you need to precalculate remainder in that case? Could you write a measure to calculate remainder and then display it on the visual you need?
Yes, I precalculate Remainder column. here is the formula. Before I calculate Remainder, I used dateadd to get a column of previous month forecast.
Remainder = IF('Sheet3'[That Month Sales]=BLANK(),Sheet3[Previous Month Forecast],MAX(0,'Sheet3'[Previous Month Forecast]-'Sheet3'[That Month Sales]))
I need 11 new columns