The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
Expected result column =
LOOKUPVALUE ( Table2[Assignee], Table2[Key], Table1[Sub-Task (Key)] )
Hi,
Please check the below picture and the attached pbix file.
Expected result column =
LOOKUPVALUE ( Table2[Assignee], Table2[Key], Table1[Sub-Task (Key)] )
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?
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.
Wanted it to display text value "Missing Assinged To". No worries. Blanks are fine too. Thank you for everything.