Forum Discussion

Ericwhv's avatar
Ericwhv
Icon for Helper II rankHelper II
5 years ago
Solved

Power BI vlookup?

Thank you everyone! i have two table Table 1 which is showing the date PO OMB Ref Date 922583377 BQ740254 19/03/2021 922583814 BQ741510 17/03/2021 922583379 BQ822800 10/03/2021...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi Ericwhv 

    Best in PQ but if you want it in DAX:

    NewCol =
LOOKUPVALUE ( Table1[Date], Table1[PO], Table2[PO Num] )

     

    		 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

     

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Ericwhv,

    In fact, you can use lookupvalue function to direct lookup other table field values if they existed related fields(e.g. table1 'id', table2 'id', you can use table1 'id' as key to search table2 other field values) even if you not link these tables with relationships.

    Introducing LOOKUPVALUE - SQLBI

    Regards,

    Xiaoxin Sheng