Forum Discussion

Stuznet's avatar
Stuznet
Helper V
7 years ago
Solved

DAX Vlookup

Hi guys,

 

I'm struggling turning this Excel formula to Dax function. So basically, I need to perform a lookupvalue based on these 2 columns. If the value is matched then return that value.

 

 

 

Thanks guys

 

Need Help
Show and Tell
Tutorial Requests
  • MFelix's avatar
    MFelix
    7 years ago

    Hi Stuznet,

     

    try the following calculated column:

     

    Column = 

lookupvalue(  Lookup[Start B]; Lookup[Finish A] ;Lookup[Start B])

     

    Regards.

    MFelix

4 Replies

    • Stuznet's avatar
      Stuznet
      Helper V
      7 years ago

      danbThanks for replying, sorry I didn't elaborate my question properly. How to do I write a lookupvalue within the same table? 

      • MFelix's avatar
        MFelix
        Super User
        7 years ago

        Hi Stuznet,

         

        try the following calculated column:

         

        Column = 

lookupvalue(  Lookup[Start B]; Lookup[Finish A] ;Lookup[Start B])

         

        Regards.

        MFelix