cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ahuh02 Regular Visitor
Regular Visitor

pivot not working power query

I am in Power Query. I want to pivot on a table with multiple values, and then take the max of each date. I go through:

- highlight my column

- transform tab--> pivot column

 

Capture.PNG

 

This results in only two columns being made, not all 6. 

 

Capture2.PNG

 

I tried manually adding the pivoted column names, but received an error:

Expression.SyntaxError: Invalid identifier.

 

Capture3.PNG

 

Any suggestions are appreciated!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
ahuh02 Regular Visitor
Regular Visitor

Re: pivot not working power query

Solution: I needed to refresh the view on the editor. A little box appeared above. I clicked this and it updated:

 

Capture.PNG

1 REPLY 1
Highlighted
ahuh02 Regular Visitor
Regular Visitor

Re: pivot not working power query

Solution: I needed to refresh the view on the editor. A little box appeared above. I clicked this and it updated:

 

Capture.PNG