Forum Discussion
Pivot in direct Query
Hi Anonymous ,
Here is my table in Power Query. The only thing I did was to change all columns to text.
Select the flag column. Go to the Transform tab, click on Pivot Column, select Name as the Values Column. Go to the advance options and select don't aggregate. You will see the following.
If this solves your issue, please mark this reply as the solution. Kudos are nice too!
Hi Anonymous ,
Here is my table in Power Query. The only thing I did was to change all columns to text.
Select the flag column. Go to the Transform tab, click on Pivot Column, select Name as the Values Column. Go to the advance options and select don't aggregate. You will see the following.
If this solves your issue, please mark this reply as the solution. Kudos are nice too!
this solution is not working in DirectQuery bro! Nathaniel_C