Forum Discussion

TungNguyen_19's avatar
TungNguyen_19
Helper III
2 years ago
Solved

How to Fill up or down base on ID column in Power Query?

Dear everyone, I have this table after Pivot    ID LOLO  BARGE TRUCKING AMFU301452 null 33 null AMFU301452 8 null null BMOU303113 14 null null BMOU303113 null 66 null...
Need Help
  • spinfuzer's avatar
    spinfuzer
    2 years ago

    Group By ID and then Operation All Rows.

     

    Change the each _ part of the formula to

    each Table.FillDown(Table.FillUp(_,Table.ColumnNames(_)),Table.ColumnNames(_))

     

     

     

spinfuzer's avatar
spinfuzer
Solution Sage
2 years ago

Group By ID and then Operation All Rows.

 

Change the each _ part of the formula to

each Table.FillDown(Table.FillUp(_,Table.ColumnNames(_)),Table.ColumnNames(_))