Repeating last calculated value

[surajde]

Hi All, 

Need help with formula for calculating below Companylist Column which is nothing but repeating Company Name and if field is blank then says "No Company". 

ID	Company	Companylist
309703748		No Company
309703748		No Company
309703748		No Company
309703748		No Company
309703748		No Company
309703748		No Company
309703748		No Company
309703748	Finserve Ltd	Finserve Ltd
309703748		Finserve Ltd
309703748		Finserve Ltd
309703748	Enable India corp	Enable India corp
309703748		Enable India corp
309703748		Enable India corp
309703748		Enable India corp
309703748	LTI	LTI
309703748		LTI
309703748		LTI
309703748		LTI
309703748		LTI
309703748		LTI
309703748		LTI
309703748		LTI
309703748		LTI
309703748		LTI
309703748		LTI

Excel formula is :

=IF(A2<>A1,IF(B2="","No Company",B2),IF(B2<>"",B2, C1 ))

[v-shex-msft]

Hi @surajde,

According to your description, I think this should be more related to data transformers requirements.

You can enter to 'query edit' and use fill down feature to fill this blank part after the existed values, then use replace function to replace the remain blank part to "No company".

Fill values in a column - Power Query | Microsoft Learn

Replace values and errors - Power Query | Microsoft Learn

Regards,

Xiaoxin Sheng

[surajde]

@v-shex-msft , 

This one is not working. Can you please check? 

Important: When ID changes then it should again start with "No Company" if Company name is blank again that record

[surajde]

Hi @v-shex-msft, thanks for the alternate work around but the method you mentioned is for existing raw data and not for calculated column. I want to write a formula that will do this