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. ...
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
I need 11 new columns