The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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 )
)
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 )
)
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
11 | |
7 |