Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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. ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

The remainder column is calculated, not in Power Query. And I have more than one company and product. Pivot doesn't work here

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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