Forum Discussion
Vlookup?
Hi
Power BI works in a different way! there is no VLOOKUP in DAX (Power BI language) instead you can use relate command to relate two tables and then you can use relate or relatetable function to grab values from your other table.
Power BI offers free training course for beginners which is really good and it will not take much time to complete. Please follow the below link for the same.
https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-0-0-what-is-power-bi/
There's no VLOOKUP function in DAX. However, you can use LOOKUPVALUE(), or use RELATED() in CALCULATE function to achieve your goal for same scenario using VLOOKUP.
Please refer to articles below:
VLOOKUP Functionality in Power Pivot
Equivalent of VLOOKUP in DAX–Part I
Equivalent of VLOOKUP in DAX – Part II – using TOPN
Regards,
Yes, its available in dax and can be used in measure.
LOOKUPVALUE(Table Column from which value need to be returned, match column for values, pass value)
This is cool!