Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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)

146922.06.2017132.16892
146907.06.20180
146929.06.2018132.16892
146904.06.2019132.16892
146914.06.2019132.16892
146916.06.20190
146925.09.2019134.87092
146909.06.2020134.87092
146907.06.2021134.87092
146903.06.2022134.87092
146910.10.2022134.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

  • ImkeF's avatar
    ImkeF
    Community 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.

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks. it works perfectly.