Forum Discussion
fraserwatt
10 years agoFrequent Visitor
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
Community Champion
You should use power query to unpivot the data. Do you know how to do that?