Forum Discussion
Logical Count Function.
I am trying to calclulate the following: When a certain date is blank, count a related date. IF(IsBlank(A Date) ,COUNT(B Date) ,Blank() *This is a direct query...
Please conisder a solution like this which creates a list of assigned loans and compares it to a list of applications =
My count =
My count =
VAR AssignedLoans =
CALCULATETABLE(VALUES(LoanTable[LoanID]),
FILTER(ALL(LoanTable),
LoanTable[AssignedDate] <> BLANK() ))
VAR Applications =
VALUES(ApplicationsTable[LoanID])
RETURN
COUNTROWS(
EXCEPT( Applications, AssignedLoans)
)
This works almost exactly how I need it to, but I think I need to specify that the loan "has" to have an application date. Would I include that filter in the 2nd VAR?
Thank you for your help,