DAX Vlookup

[Stuznet]

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

[danb]

Try the LookupValue function

[Stuznet]

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

[MFelix · Accepted solution]

Hi @Stuznet,

try the following calculated column:

Column = 

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

Regards.

MFelix

[Stuznet]

Thank you 🙂