Cannot Pivot months when using the Table.Pivot function

J

jazzista

Member
Joined
Jan 4, 2017
Messages
50
Reaction score
0
Points
6
Excel Version(s)
Office 365
Hello Forum. I am trying to pivot a list of projects with dates into a Matrix in Powerquery . I am able to pivot the project numbers into the values field BUT when I try to pivot the dates instead of the project number i got nulls instead. How can I pivot so that the dates show inside the matrix? Any help would be very appreciated. File attached. The file that i am trying to covert is called error and it is the last query in the file. Thanks
 

Attachments

  • pivot dates.xlsx
    35.7 KB · Views: 5
Is error(2) in the attached what you're looking for?
 

Attachments

  • ExcelGuru11375pivot dates.xlsx
    39.8 KB · Views: 10
p45cal: Yes indeed.. that's the result i was looking for. Thank you very much... What did you do different ? I was very frustrated after many attempts !
 
I left the error query as it was so that you could see the differences; essentially
  • added an index
  • pivoted
  • removed the index.
 
Last edited:
p45cal . Thanks again. I will look into the steps... specially adding the index column to get the desired results. Appreciated your help.
 
You must log in or register to reply here.
Back
Top