Forum Discussion
Solved
Power Query AddColumn with data from other table runs slow with List.PositionOf
I need to capture the data from the 'Answer' Column in Table1 into the new 'Answer' column in Table2. Where the tables have a many to many relationship in the Column 'Names'. And if there is no mat...
I ended up adding a column with "= Table.ReplaceValue(#"Replaced Errors",null,"No",Replacer.ReplaceValue,{"SelfMed"})" as the code.
It's not power query but you could create a DAX calculated column on the Table2 table for this:
Answer =
IF( ISBLANK(SelectedValue('Table1'[Answer])), "No", SelectedValue('Table1[Answer])