Forum Discussion
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 |
| BMOU303113 | null | null | 138 |
How to Fill up or Fill down base on ID column in Power Query? The result will be like this:
| ID | LOLO | BARGE | TRUCKING |
| AMFU301452 | 8 | 33 | null |
| AMFU301452 | 8 | 33 | null |
| BMOU303113 | 14 | 66 | 138 |
| BMOU303113 | 14 | 66 | 138 |
| BMOU303113 | 14 | 66 | 138 |
In power query we only have option Fill down or Fill up only so I think this must be customized by M Language. Can anyone help me, many thanks to you guys ❤️
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(_))
1 Reply
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(_))