Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
kt3734
Frequent Visitor

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 to stop it.  Can you tell me why?- Thanks

 

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

 

Result before adding the filter above.

kt3734_1-1676316684805.png

 

1 ACCEPTED SOLUTION
BrianConnelly
Resolver III
Resolver III

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 ) 

)

View solution in original post

1 REPLY 1
BrianConnelly
Resolver III
Resolver III

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 ) 

)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.