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.
Hey guys,
I need to compare values between two columns, A and B.
The values in question come from json, and each column is an array of values. I managed to break these values by commas, but I need to identify which values do not exist between these two columns.
Is there any way to do this?
Example image
Solved! Go to Solution.
Hi @AlanCruz
=Text.Combine(
List.Difference(
Text.Split([Col A], ","),
Text.Split([Col B], ",")),
",")
Stéphane
Hi @AlanCruz
=Text.Combine(
List.Difference(
Text.Split([Col A], ","),
Text.Split([Col B], ",")),
",")
Stéphane