Forum Discussion
navafolk
Helper IV
Helper IVPower Query - dynamically query group of columns (groups are delimited by blank columns)
Hi pros, I have a product report of all GROUP by date, each GROUP is delimited by at least 1 blank column. It looks like: My focus is GROUP2, but columns of GROUP2 are moved quite often si...
ok, pls try again
navafolkHelper IV
Helper IVThank you, Ahmedx.
The product structure here is very dynamic, it can be 3 products, sometimes it has only 1 product.
ListColumns = {Table.ColumnNames( from){0}} & List.LastN( Table.ColumnNames( from),2),So, your ListColumns step (that took 2 last columns for GROUP2) may not dynamic enough to cover product structure changes.
