filter

[kt3734]

Hi, I run my dax query query returned the result with all the  dates below.  However, when I add the addition below  to the query then then it  keeps Executing the query for a long time then I have to stop it.  Can you tell me why?- Thanks

FILTER ( 'Backlog','Backlog'[InvDate] <=TODAY()-15) 

Result before adding the filter above.

[BrianConnelly · Accepted solution]

Not sure as there is not enough detail, but we could modify your filter.   What does the performance analyzer tell you?

Try this....

VAR dateMarker = TODAY()-15

CALCULATE( .........

FILTER ( ALL('Backlog'[InvDate]), 'Backlog'[InvDate] <= dateMarker ) 

)