I am working on a BI report where I need to create a count based on two specific items and don't know how to input two (2) where clauses in a variable.
Here is what I have so far:
=Count(([Appt Date Time]) Where [Status] = "ATTENDED") And Where(([Appt Date Time]) Between ([Vt Prim Ins Effective Dttm];[Vt Prim Ins Expiration Dttm]))
I don't know if I can make two seperate counts to get the specific items I am looking for and what I am doing wrong to get the error on the above variable.
Thank you in advance for any help you can provide.