Lookup Value in Power Query

[Anonymous]

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.

[v-luwang-msft · Accepted solution]

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

[amitchandak]

@Anonymous , Lookup in power query is like joining two tables and getting information out

https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/

I would suggest to consider DAX too

refer 4 ways to copy data from one table to another in my 2 videos
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8