Forum Discussion
Analitika
Post Prodigy
Post ProdigyTransforming data in Power BI
Hi,
I need to transform data.
Now I have this situation:
But I need to transform table in order to get something like this:
If you go into transform
data (Power Query).
Select the objective and name columns (hold shift). Then find the unpivot button, clixl
down arrow and click unpivot other columns.
You can then rename the columns.
2 Replies
- bcdobbs
Community Champion
If you go into transform
data (Power Query).
Select the objective and name columns (hold shift). Then find the unpivot button, clixl
down arrow and click unpivot other columns.
You can then rename the columns.