Forum Discussion
Power BI IF Nested With Vlookup
Hi All,
I just started using Power BI and I have an Excel Model I would like to replicate in Power BI. One of the formulas that I'm having trouble with is the below:
=IF(B2="Default",VLOOKUP(G2,Lookup_Data,!AR:AT,3,FALSE),B2).
Does any know how to replicate this in Power BI?
Best,
Imran
5 Replies
Imran_Isshack as I mentioned, you have to keep excel aside and think differently. First and foremost, how many tables are there? What's their relationship like one to many, many to many? Which table needs to have this new value?
Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Imran_Isshack Power BI is a model-based solution, not necessarily need vlookup kinda solution here, depends on how different tables are related in Power BI. You can always check LOOKUPVALUE DAX function. LOOKUPVALUE function (DAX) - DAX | Microsoft Docs
✨ Follow us on LinkedIn
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Parrry2K,
Thanks very much for your response. I'm just looking for some ideas, on how to do this. in Power BI. I know how to map tables, create relationships in Power Query which is similar to Power BI. I'm just not sure how to go about replicating this formula in Power BI.
Imran
Hi Imran_Isshack,
Could you provide sample data and expected output after removing sensitive data?
Sample data and expected output would help tremendously.Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
Hi Xulin,
Apologies for the delayed response. This project is on a hold.
Best,
Imran
