Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. 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 @ZHC
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 @ZHC
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
87 | |
84 | |
73 | |
49 |
User | Count |
---|---|
143 | |
131 | |
110 | |
64 | |
55 |