Stacking Paired Columns

Stacking Paired Columns


  1. Max – another approach to generating a ‘Modulo’ index would be use the GroupBy function – group  by Cost.ID & count ‘All Rows’.  When expanding hack the code by adding the bolded text below. IMV – you get a better sub index value.

    = Table.Group(#”Split Column by Delimiter”, {“Cust.ID”}, {{“Count”, each Table.AddIndexColumn(_, “Modulo”, 1,1), type table}}).

    Thank you,



    • Hi Drew!
      Yes, it is also cool way to add grouped index, but I didn’t tested performance to compare both methods. Do you have any ideas about performance?

Leave a Reply

Your email address will not be published / Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.