Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
3.1k views
in Power BI by 15 17 24

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?


1 Answer

1 like 0 dislike
by 54 119 241
selected by
 
Best answer

RELATED Vs LOOKUPVALUE DAX

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.

Lookupvalue vs related comparison in Power BI

As you can see in the above table, RELATED and LOOKUPVALUE have the same result, however, each function has its own syntax and usage.


When to use RELATED function in Power BI?

You should use the RELATED DAX function if the current two tables have already a relationship.

use related function with one-one relationship tables in Power BI

For more details, Please check What’s RELATED DAX Function? and When you should use it?

When to use LOOKUPVALUE function in Power BI?

You should use the LOOKUPVALUE function if you can’t create a relationship between the two tables.

use related function with two unrelated tables in Power BI

For more details, Please check What’s LOOKUPVALUE DAX Function? and When you should use it?

Which DAX function is good for performance?

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

by 15 17 24
0 0
Links very helpful, thank you!
If you don’t ask, the answer is always NO!
...