Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Using Power Query, I need to check for each row of MyTable if the value in column B exists in column A.
If it does, then that value should be returned, then an empy field.
This is the code I'm trying to enter into an if statement somehow:
Table.Contains(MyTable,[B],[A])
Which is returing a cyclical reference error.
Assuming this is in AddColumns...
Just use:
if Text.Contains([A], [B]) then [B] else null
Hi @artemus
thanks, it always returns B (since B is a substring of A).
I need to make an exact comparison, is there a function for that?
Oh, just use:
if [A] = [B] then [A] else null
I think I see what you are getting at.
In this case instead of adding a column, do a self join. Just do a merge on the same table using [A] and [B] as the join columns
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.