Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Very Specific Conditional Fill Down

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..

Need Help
Tutorial Requests
  • dufoq3's avatar
    dufoq3
    2 years ago

    Hi Anonymous, 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

2 Replies

  • dufoq3's avatar
    dufoq3
    Community Champion
    2 years ago

    Hi Anonymous, 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
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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.. !