Forum Discussion

fraserwatt's avatar
fraserwatt
Frequent Visitor
10 years ago

Column totals as rows?

I'm working with a dataset where the columns provided are something to the effect of

 

Product | Month 1 | Month 2 | Month 3 | Month 4 etc

 

but what I need it is in the format

 

Revenue

Month1

Month2

Month3

 

I'm assuming the best way to do this would be a calculated table using a DAX statement but not sure how to approach?

 

Thanks

1 Reply

  • MattAllington's avatar
    MattAllington
    Icon for Community Champion rankCommunity Champion

    You should use power query to unpivot the data. Do you know how to do that?