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...
Would it matter if the blank date is in a different table? I am not getting any errors, but the count is not showing on a card.
Thank you,
Please can you elborate and describe the 2 files.
Are you saying you have 2 files each with a list of dates and you want to count which dates are on table A but not on table B?
This will count dates on B but not on A
My count =
VAR lista = VALUES(tableA[date])
VAR listb = VALUES(tableB[date])
RETURN
COUNTROWS(
EXCEPT(listb, lista)
)