Forum Discussion
Group by Rows then FillDown does not work
Hi,
I have some missing values in the column "Projektkosten (Geplant) (MFr)". I would like to fill the missing data from the previous "Exportdatum" that has the same "PMS-ID".
Sample data:
ID, PMS-ID, Exportdatum, Projektkosten (Geplant) (MFr)
| 14 | 69 | 22.06.2017 | 132.16892 |
| 14 | 69 | 07.06.2018 | 0 |
| 14 | 69 | 29.06.2018 | 132.16892 |
| 14 | 69 | 04.06.2019 | 132.16892 |
| 14 | 69 | 14.06.2019 | 132.16892 |
| 14 | 69 | 16.06.2019 | 0 |
| 14 | 69 | 25.09.2019 | 134.87092 |
| 14 | 69 | 09.06.2020 | 134.87092 |
| 14 | 69 | 07.06.2021 | 134.87092 |
| 14 | 69 | 03.06.2022 | 134.87092 |
| 14 | 69 | 10.10.2022 | 134.87092 |
I have used Groupby and fill with the following command
= Table.Group(
#"Sorted Rows1",
{"PMS-ID"},
{{"Rows", each Table.FillDown(_, {"Projektkosten (Geplant) (MFr)"}), type table}}
)
The command works without errors, but does not fill the missing data.
Any idea why the Filldown may not be working?
Hi Anonymous ,
the fill down works on null values, not 0. So after you replace 0 by null, you should see the expected result.
Make sure to transform the column to number first to make sure only complete fields will be replaced.
2 Replies
- ImkeFCommunity Champion
Hi Anonymous ,
the fill down works on null values, not 0. So after you replace 0 by null, you should see the expected result.
Make sure to transform the column to number first to make sure only complete fields will be replaced. - AnonymousNot applicable
Thanks. it works perfectly.