- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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..
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.. !

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
12-23-2024 05:18 AM | |||
10-23-2024 03:53 AM | |||
11-23-2023 04:24 PM | |||
10-17-2021 02:45 AM | |||
10-03-2024 10:26 AM |
User | Count |
---|---|
27 | |
25 | |
25 | |
13 | |
9 |
User | Count |
---|---|
24 | |
19 | |
16 | |
13 | |
9 |