Given the following scenario:
Table_A includes a 'zipcode' column.
Table_B also includes a 'zipcode' column, as well as a 'city' column and a 'value' column.
The relationship between the zipcode in Table_A and the zipcode in Table_B is a many to many relationship.
What we want to do is create a Power Fx formula column in Table A that pulls the first found value of 'city' from Table_B into Table A where the zipcodes match AND the value column is equal to or greater than 0.5.
Given that we know the syntax for Lookup is: LookUp(Table*, Formula [, *ReductionFormula* ] )
Will the following function work when defining the Power Fx formula column in Table A?
Lookup (Table_B, zipcode = Table_A.zipcode && value >= 0.5, city)
