Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ❤️
Solved! Go to Solution.
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(_))
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(_))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.