Forum Discussion

brisacisneros's avatar
brisacisneros
New Member
1 year ago
Solved

Pivoting Columns with Duplicate ID and Date

Hi everyone, I'm having trouble pivoting columns in Power Query when I have duplicate IDs and dates in my data. My goal is to have one row for each unique combination of ID and date, with the corres...
Need Help
Tutorial Requests
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi brisacisneros,

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if your issue is resolved? or let us know if you need any further assistance.
    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

     

    Thanks and regards,

    Anjan Kumar Chippa

Omid_Motamedise's avatar
Omid_Motamedise
Super User
1 year ago

After using Pivoting, in the setting use sum operation, then in the result formula in the formula bar, replace List.Sum with each _{0} will solve your problem.