PowerBI - table auto filling

CJC_DB , You can have a new column

coalesce([Status], "B")

or replace with one value

or find a value and replace

coalesce([Status], maxx(filter(Table, [Part no] = earlier([Part no]) ) , [Status])

Hi, CJC_DB 

You can try the following methods.
Column:

Column = CALCULATE(MAX('Table'[Status]),FILTER('Table',[part no]=EARLIER('Table'[part no])))

Column 1 = CALCULATE(MAX('Table'[Status.1]),FILTER('Table',[part no]=EARLIER('Table'[part no])))

Are these 2 columns the output you expect?

Best Regards,

Community Support Team _Charlotte

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