Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX Calculation from related table

Hi all,   I have this DAX expression and it works fine.   PTD Sales = CALCULATE ( SUM ( Transactions[Sales] ), FILTER ( Transactions, Transactions[period_year] = MAX ( Transactions[period_...
Show and Tell
  • Anonymous's avatar
    Anonymous
    7 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Anonymous :)

 

But i was not referring to the formatting itself, rather more the logic to ensure it is working efficiently

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.