Wondering... is there a way to do a vlookup function in power bi?

[Anonymous]

Hi, Wondering... is there a way to do a vlookup function in power bi? If so is there a way to replicate this. 

Dropbox file link: https://www.dropbox.com/scl/fo/c1m1aqyklj104p8ip7xzd/h?dl=0&rlkey=ujhzsfv8bom9e5zv6ltf9dwr7

I do not know how to get the same result in Power bi. Here is the folmula used in Excel. 

 All I want to do is replicate column C 

 V-LOOKUP Jira_Subtask Assignee Name OR Not Match Found in PowerBi. 

=IFERROR(VLOOKUP([@[Sub-Task (Key)]],Jira_Subtasks!A:B,2,0),"Missing Assinged To Name ")'

Any assitance would be wonderful.

Thank you. 

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Expected result column =
LOOKUPVALUE ( Table2[Assignee], Table2[Key], Table1[Sub-Task (Key)] )

[Anonymous]

@Jihwan_Kim 

This is what I am looking for (Thank You! 🙏) but I need for the syntaxt to display Missing Assinged To Name when value is null (AKA Blank). How would I put that into this format into this syntax?

[Jihwan_Kim]

Hi,

Sorry that I am not 100% sure whether I understood your question correctly.

Please check the attached file.

The DAX calculated column still uses the same formula, and displays blank when the asignee value is null.

[Anonymous]

Wanted it to display text value "Missing Assinged To". No worries. Blanks are fine too. Thank you for everything.