Forum Discussion
Solved
filter
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 t...
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 )
)
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 )
)