Fill blank rows with the top row value

[Anonymous]

Hello all,

I have a table with column name identity number. Here , if a id number for few columns/rows are same, it will just have top row value and all down will be blank as their value is also same. so, in power bi i want this blanl values to be filled with top latest row value. 

sample data:

Id No;
1

5

8

9

10

So blank values to be filled with respective top most data.

[v-lionel-msft]

Hi @Anonymous ,

Here's my sample data:

Then, I use "Fill Down" feature:

Is this what you want?

If not, please give a more complete sample data.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-lionel-msft iam trying the same, why iam unable to do so...by the way, my blank rows are as just blank , not null

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Only when the value is "null" can use "Fill Down" feature:

"by the way, my blank rows are as just blank , not null"

So, you need to do like this:

First, replae blank with "null";

Second, Fill down

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pabeader]

Blank and null are two very different things.  Your 'blank's are most likely a non visible character like a space.  So first you would have to replace those with null and then do the fill down.

[Greg_Deckler]

In Power Query, use the Fill Down feature on the column.

[Anonymous]

@Greg_Deckler I can't see such feature in query editor. can you please provide the path

[Anonymous]

Fill down option not working