Forum Discussion
Repeating last calculated value
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...
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
Hi Anonymous, 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