Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
94 | |
87 | |
79 | |
76 | |
69 |
User | Count |
---|---|
116 | |
107 | |
88 | |
64 | |
63 |