Very Specific Conditional Fill Down

[ferby2023]

Hi guys, i think the picture explains itself:

Basically I am trying to fill down based on an ID column.. i tried lot of thing, even aggregation but i could find out how to solve, any ideais on how to do this?

The values in column "VALUE" are very random. it comes in different months..

[dufoq3 · Accepted solution]

Hi @ferby2023, check this:

Result

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("Xc4xDsAgDEPRu2RmIKZAu3fpGRD3v0aViko2A8O3FPTGsOd2SxbPZvoTmkXz0KxxkGloccJDjyMeTv3h0vS89aZz4kHxUDwUD8Vj4SmbZtcMtlcaAg4ePnqRZdMt/HwB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Tag = _t, Month = _t, Value = _t]),
    ChangedType = Table.TransformColumnTypes(Source,{{"Month", Int64.Type}, {"Value", type number}}),
    GroupedRows = Table.Group(ChangedType, {"Tag"}, {{"All", each Table.FillDown(_, {"Value"}), type table}}),
    Combined = Table.Combine(GroupedRows[All])
in
    Combined

[ferby2023]

thanks for helping.. I was able to paste the code, but unfortunately when I clicked on Save the query never stopped. 

Waiting for other queries... for at least 40 min.

My ID tag is very very very big, because it is a concatenation of many columns.

EDIT: after +- 1 hour it worked! 

@dufoq3  many thanks.. !