Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ))
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |