When you cannot fill up nor down

[ValentinBIA]

Good morning Power BI community !

I'm struggling to fill in the "null" lines, since I cannot use fill up nor fill down (both would give me wrong values), and I don't really know what to do next.

I'm currently trying using an index and some formula to only fill down if the value on the id column is the same as the value on the id column but one row above.

Can you help me there ?

Thank you very much

[Vvelarde · Accepted solution]

@ValentinBIA

One Way is

1. Duplicate the Query .. Group By ID    -    Max of Each Column (Gender , Range).

2. Merge Queries - By ID

3. Expand Gender, Range

Victor