The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Good Afternoon,
After hours of research, I don't understand how to solve the following problem:
I have a table with several columns, including column A which contains a character string and column B which also contains a character string.
I would like a formula that allows me to have an additional column in which there would be "TRUE" if the values entered in column A are also present in column B.
The values in column A can be present several times in column B.
Ex : if my value A2 is present in line 50 of the column B, then we return TRUE otherwise we return FALSE.
Does anyone know how to do this?
Have a good day,
Charlotte
Solved! Go to Solution.
Hi @Charlott_9,
If I correctly understand your explanation, you need a calculated column like this:
Best Regards,
Alexander
Hi @Charlott_9,
If I correctly understand your explanation, you need a calculated column like this:
Best Regards,
Alexander
Hi,
It answers my request perfectly! Thanks a lot!
Have a good day,
User | Count |
---|---|
26 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
28 | |
13 | |
12 | |
12 | |
6 |