Forum Discussion
DAX Calculation from related table
I can't tell you the best way to write your particular DAX expression. However, since you are interested in optimizing your DAX, sqlbi.com always publish articles about the best way to optimize DAX.
Here is a link to their most recent articles on DAX optimization:
https://www.sqlbi.com/articles/?author=&tag_id=411
Also, they have DAX studio which allows you to test how long your DAX takes to run. You can change things up to see if your DAX changes affect performance.
Hope that helps.
Great question.
If you are formatting your DAX properly, which you are obviously doing based on your latest post, you are following best practices with respect to writting/formatting DAX.
Keeping up with best practices and your workload can be difficult. The staff at SQLBI do a lot of work to educate people regarding best practices; there is also great content on this board.
If you haven't already, check out sqlbi.com. Marco is in some vids with the doods that create Guy In A Cube YouTube content.
Well done!
Thanks Anonymous :)
But i was not referring to the formatting itself, rather more the logic to ensure it is working efficiently
I can't tell you the best way to write your particular DAX expression. However, since you are interested in optimizing your DAX, sqlbi.com always publish articles about the best way to optimize DAX.
Here is a link to their most recent articles on DAX optimization:
https://www.sqlbi.com/articles/?author=&tag_id=411
Also, they have DAX studio which allows you to test how long your DAX takes to run. You can change things up to see if your DAX changes affect performance.
Hope that helps.