Excel Queries - Working with pivoted columns RRS feed

  • Question

  • Hi! Hope someone can help )

    Is it possible to make a totals column for a dynamic range? So the total will still be true even if the number of columns created changes?

    Currently I have to specify the column names that I want to total meaning as soon as a new column is created by the query the total is no longer correct :(

    Sunday, January 7, 2018 11:19 PM


  • There are a few ways to add the step for the "Weeks Worked" column to provide a dynamic total, e.g.

    AddedCustom = Table.AddColumn(<PreviousStepName>, "Weeks Worked", each List.Sum(List.Skip(Record.ToList(_))))

    Monday, January 8, 2018 2:24 AM