Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Lookup Value in Power Query

Hi Experts

 

I have two tables in Power Query Table A and Table B Both Tables have only one column and If the Stock ID in Table A in not in Table B then add a new column to Table B with text "Investigate". i,e we have additional stock id's in table b.

Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    5 years ago

    HI Anonymous ,

    See the below ,is it what you want?

     

    a sample:

    Table A and Table B:

     

    If    values about not in table A, also in table B,then "Investigate"，otherwise  blank:

    Then use the following dax to create a new column:

    Column = if(NOT(ISBLANK(RELATED(TableB[test])))=FALSE(),"Investigate",BLANK())

     

    Final you will get :

     

    Wish it is helpful for you!

     

    Best Regards

    Lucien

2 Replies