The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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..
Solved! Go to Solution.
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
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
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.. !