Forum Discussion
How to fill down values in one column based upon distinct values in another?
Hello. I have a dataset which has gaps in a certain column ('Updates') I would like to fill down according to the distinct values in another column ('Server'): The values in 'Update' are a...
Hi
= Table.Combine(
Table.Group(
Your_Source,
{"Server"},
{{"Data", each Table.FillDown(_,{"Updates"}), type table [Server=number, Events=number, Updates=nullable number]}}
)[Data]
)Stéphane
Hi macolmedo10
replace "Server" by "Location" and "Updates" by "Bayer Name"
= Table.Combine(
Table.Group(
Your_Source,
{"Location"},
{{"Data", each Table.FillDown(_,{"Bayer Name"})}}
)[Data]
)
Stéphane
I am not sure what i am doing wrong but it is giving me an error
I am really new . when you mean source it is the excel source yes?