Forum Discussion

ecabanas's avatar
ecabanas
Regular Visitor
2 years ago
Solved

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.

2 Replies

  • Highlight your dateid column and click "unpivot other columns" in the transform ribbon.