Forum Discussion

KNP's avatar
KNP
Icon for Super User rankSuper User
7 years ago
Solved

Power Query - Aggregate Columns with Dynamic Column Names

Hi,   After much unsuccessful googling, I'm looking for help dealing with aggregating column names that are dynamic. I'm sure there's a simple pattern or function to do this but I have Friday brai...
Need Help
  • ImkeF's avatar
    ImkeF
    7 years ago

    Hi KNP 

     

    You can use this formula to make the solution dynamic:

     

        #"Aggregated data"  = Table.AggregateTableColumn(Source, "data", List.Transform(DistinctValue, each {_, List.Sum, "Sum of " &_}))
KNP's avatar
KNP
Icon for Super User rankSuper User
7 years ago
I don't think this helps me.
It's not about renaming columns.
  • KNP's avatar
    KNP
    Icon for Super User rankSuper User
    7 years ago

    Hi ImkeF, 

     

    Do you have any idea how to best acheive this?

    I currently have a very poorly performing solution.

     

    Thanks,

    Kim

    • ImkeF's avatar
      ImkeF
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Hi KNP 

       

      You can use this formula to make the solution dynamic:

       

          #"Aggregated data"  = Table.AggregateTableColumn(Source, "data", List.Transform(DistinctValue, each {_, List.Sum, "Sum of " &_}))
      • KNP's avatar
        KNP
        Icon for Super User rankSuper User
        7 years ago

        Thank you ImkeF. 

        The correct syntax looks so simple when you know it well. 

        I really appreciate you taking the time to help with this. 

         

        I will test/implement as soon as I get back to that project before I mark this as the solution. 

         

        Thanks again,

        Kim