Group by Rows then FillDown does not work

[Anonymous]

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?

[Anonymous]

Thanks. it works perfectly. 

[ImkeF · Accepted solution]

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.