Replacing Nan with the value of the previous non-NaN row in the same column

[hagosusng]

Hi,

I want to convert all the NaN into the value of the previous row that have a non NaN value. Please can anyone help me.

I have looked uo the below link, but it wasn't helpful

Solved: Power Query- how to replace null with previous row... - Microsoft Power BI Community

Thank you in advance 

[tamerj1 · Accepted solution]

Hi @hagosusng 

you can Replace Values "NaN" with null then Fill Down

[hagosusng]

I have the data in PowerBI

[hagosusng]

Ho do i Fill Down?

[tamerj1 · Accepted solution]

@hagosusng 

You need to do this data transformation using power query. Open the query editor as per the following screenshot 

 Right click on the column that you want to perform transformation on and select "replace values" then right click again and select "fill" "down"

[tamerj1 · Accepted solution]

Hi @hagosusng 

you can Replace Values "NaN" with null then Fill Down