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

can you just confirm the structure of your model - is the transaction date connected to the date dimension via a date key? 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yes the Transactions table is connected to the DateKey, so relationships are established already.

 

Thanks Anonymous