Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello All
I have a table A with all customers accounts and company names. However, due to acquisition/merging/demerging, some company names are changed. Table B has all the changed company names. As shown below.
because of reporting requirements, I don't want to replace the company name in Table A. I want to add a new column "Updated name" in Table A, on condition that if account # in table B, take the company name in Table B, otherwise keep the company name in table A. Unfortunately there are empty company name in Table A.
Is it achievable without merging tables? I used CONTAINSSTRING
Updated name = if( CONTAINSSTRING('Table A'[Account No], 'Table B'[Account No]), 'Table B'[Account new], 'Table A'[Company])
But I got error "A single value for column 'Account No' in table B cannot be determined."
Can anybody help me solve the issue. Many thanks in advance.
Solved! Go to Solution.
Hi @Anonymous
Download PBIX file with example below
This will create the column in TableA
Updated Name = IF(RELATED(TableB[Account No]) = [Account No], RELATED(TableB[Company Name]), 'TableA'[Company])
Regards
Phil
Proud to be a Super User!
Hi @Anonymous
Download PBIX file with example below
This will create the column in TableA
Updated Name = IF(RELATED(TableB[Account No]) = [Account No], RELATED(TableB[Company Name]), 'TableA'[Company])
Regards
Phil
Proud to be a Super User!
It works perfectly. Thank you very much.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
63 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
82 | |
62 | |
45 | |
41 | |
40 |