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.
Hello:
I have used the following Formula:
Solved! Go to Solution.
Hi, @Anonymous
I have simulated some data, you can try the following methods.
PWC Past Due =
CALCULATE (
COUNTROWS ( Table_query__1 ),
FILTER (
ALL ( Table_query__1 ),
Table_query__1[Overall Status] = "Completed"
|| Table_query__1[Overall Status] = "In-Progress"
&& BLANK ()
&& (
SELECTEDVALUE ( Table_query__1[PwC Actual Complete Date] ) <> BLANK ()
|| SELECTEDVALUE ( Table_query__1[PwC Actual Complete Date] ) < TODAY ()
)
)
)
Does getting this result in this data match the output you want?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
I have simulated some data, you can try the following methods.
PWC Past Due =
CALCULATE (
COUNTROWS ( Table_query__1 ),
FILTER (
ALL ( Table_query__1 ),
Table_query__1[Overall Status] = "Completed"
|| Table_query__1[Overall Status] = "In-Progress"
&& BLANK ()
&& (
SELECTEDVALUE ( Table_query__1[PwC Actual Complete Date] ) <> BLANK ()
|| SELECTEDVALUE ( Table_query__1[PwC Actual Complete Date] ) < TODAY ()
)
)
)
Does getting this result in this data match the output you want?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Try like
PWC Past Due = CALCULATE(COUNTROWS(Table_query__1),
FILTER(Table_query__1,(Table_query__1[Overall Status] in {"Completed", "In-Progress"} || isblank(Table_query__1[Overall Status]))
&& ISBLANK(Table_query__1[PwC Actual Complete Date]) || Table_query__1[PwC Actual Complete Date]<TODAY()))