Forum Discussion
Solved
Count Records Based off of Date Calculation
I have written a measure to determine the next upcoming Friday's date based off of today's date. I'm sure there is a better way, but basically I used a combination of CALCULATE, IF and WEEKDAY to de...
You should use FILTER function as a filter argument in the CALCULATE. Something like below...
Due_By_FRI = CALCULATE(COUNT([defect_id],[defect_status]<>"Closed",[defect_status]<>"Rejected",FILTER('defectstable,[ECT]<=[FRI_DTE]))
Is [ECT] a measure or column?
BhaveshPatel
Super User
Super UserYou should use FILTER function as a filter argument in the CALCULATE. Something like below...
Due_By_FRI = CALCULATE(COUNT([defect_id],[defect_status]<>"Closed",[defect_status]<>"Rejected",FILTER('defectstable,[ECT]<=[FRI_DTE]))
Is [ECT] a measure or column?
Thank you very much Bhavesh! This worked great and gave me the results just like I wanted. To answer your question, ECT is a column in the table data.
Thanks,
Craig