I am new to DAX, and I need to know the main differences between RELATED Vs LOOKUPVALUE DAX functions in Power BI? and when I can use the RELATED DAX function and LOOKUPVALUE DAX function, and which DAX function is good for performance in Power BI?
RELATED and LOOKUPVALUE are DAX functions that used in a calculated column when you need to reference columns from another table to the current table.
As you can see in the above table, RELATED and LOOKUPVALUE have the same result, however, each function has its own syntax and usage.
You should use the RELATED DAX function if the current two tables have already a relationship.
RELATED
For more details, Please check What’s RELATED DAX Function? and When you should use it?
You should use the LOOKUPVALUE function if you can’t create a relationship between the two tables.
LOOKUPVALUE
For more details, Please check What’s LOOKUPVALUE DAX Function? and When you should use it?
For better performance, it’s more efficient to use the RELATED function rather than the LOOKUPVALUE function if you CAN establish a relationship between the two tables.
See Also
1k questions
670 answers
451 comments
193k users
Related Activities
Categories
Most popular tags