Fill blank cells in a column with previous non blank

[Anonymous]

Good day

I am trying to fill blank cells in a column with previous non blank cell from that column. This is the formula I used

Code

I am not getting the desired result

Bench table

[amitchandak]

@Anonymous , try like

if(isblank(Table1[bench] )
maxx(filter(table, table[Eqmt Type] = earlier[[Eqmt Type] && table[interval end] < earlier[interval end]   
		),LASTNONBLANKVALUE(Table1[interval end],max(Table1[bench]))),Table1[bench])

[Anonymous]

Hi @amitchandak 

I am getting an error

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[parry2k · Accepted solution]

@Anonymous see attached, I have included a couple of options, you can tweak it as per your business rules.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[danb]

Your mock up just solved the same problem for me! Many thanks! 

[user023]

I signed in just to express that this one help me to solve my problem, thankyouu so much. 

[Anonymous]

@parry2k 

Thank you so much!

[camargos88]

Hi @Anonymous ,

You can do it using Power Query, the function Fill Down does it. Just replace any spaces for null and apply it.

Result:

[Anonymous]

Hi @camargos88 

I am using a summarized table from 2 different queries.

Thanks