Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Group by Rows then FillUp & FillDown for multiple columns

Hello,   I'm trying to clean data on a project database where incremental information is added over time: Project NameDateRegionStyleSize CAM 1/21/2020 Africa   Large CAM 6/10/2020   ...
Need Help
  • shaowu459's avatar
    shaowu459
    5 years ago

    Hi Anonymous , try this. Source is the table you upload to PQ editor.

    = Table.ReverseRows(Table.FillDown(Table.ReverseRows(Table.FillDown(Source,{"Region","Style","Size"})),{"Region","Style","Size"}))

shaowu459's avatar
shaowu459
Resolver II
5 years ago

Hi Anonymous , try this. Source is the table you upload to PQ editor.

= Table.ReverseRows(Table.FillDown(Table.ReverseRows(Table.FillDown(Source,{"Region","Style","Size"})),{"Region","Style","Size"}))