Forum Discussion
ecabanas
2 years agoRegular Visitor
How to do that? colum data to registers
Hi all,
This is my first post, and I need your help.
I'm importing a table with dimensions on left and data per columns (january, february, etc). I uploaded the data to PBI but I want to import the data as a different way.
As you can see, I have dateid and values for revenues (ventas) cost , etc.
But I want to put every revenues, cost and margin in a table that has, concet (revenue, cost, etc) dateid and value. For example:
Any idea how to transpose the info in records?
Thanks
Highlight your dateid column and click "unpivot other columns" in the transform ribbon.