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
Anonymous ,
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