Forum Discussion

DianaChris's avatar
DianaChris
Frequent Visitor
3 years ago
Solved

Achieving IF statement referencing another table in Power Query

Hi All,

 

Can we achieve IF statement in Power Query by referencing another table's column without approaching DAX?

Eg. IF(table1(columnvalue)=table2(columnvalue) then table1(columnvalue) else "Unknown")

 

Please help me with this.

 

Need Help

2 Replies

  • rsbin's avatar
    rsbin
    Community Champion
    3 years ago

    DianaChris ,

    I think if you make use of the "Merge Queries" function in Power Query, you will get what you are after:

    https://learn.microsoft.com/en-us/power-query/merge-queries-overview

     Merge your table2 [columnvalue] into table1 using the Full Outer Join (all rows from both tables).

    Then you can continue to manipulate the data in your table1 as per your requirements.

    Trust this will help resolve your question.

    Regards,