Forum Discussion
LE2023
2 years agoNew Member
How to pull data through
Hi all, Very new to powerbi. I can import data and pull data out when it is simplified and just in a column. However, when data is in this format: And I would like to pull revenue for e...
- 2 years ago
LE2023 Go into Power Query Editor. Select your first column, right-click and choose Unpivot other columns. You will now end up with 3 columns and this will be far easier to do what you are trying to do.
Greg_Deckler
2 years agoCommunity Champion
LE2023 Go into Power Query Editor. Select your first column, right-click and choose Unpivot other columns. You will now end up with 3 columns and this will be far easier to do what you are trying to do.