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...
See Below: All of my tables are Related Direct Queires from SQL. I am wanting to track how many loans are in the application process.
To do so, I am using dates. So in my main database, I am wanting to know how many loans that have an application date, but do not have an assigned date.
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)
)