Forum Discussion
Fill blank rows with the top row value
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.
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
- Greg_Deckler
Community Champion
In Power Query, use the Fill Down feature on the column.
Greg_Deckler I can't see such feature in query editor. can you please provide the path
v-lionel-msftCommunity Support
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
