Count if date greater than specific date

[fs_]

Hi together!

I try to create a KPI that show how many logins happened since 01.06.2022 (DD.MM.YYYY).

The table looks like this:

UserID | First Login

ABC | 31.05.2022 12:00:00

DCF | 03.06.2022 12:00:00

I tried the following expression to only count First Logins that happened 01.06.2022 or later:

count({<[First Login.autoCalendar.Date]={'>'date(31.05.2022,'DD.MM.YYYY')}}[First Login.autoCalendar.Date])

But it does not work.

[fs_ · Accepted solution]

I found a solution. My syntax was wrong. What worked for me was:

count({<[First Login.autoCalendar.Date]={">31.05.2022"}>}[First Login.autoCalendar.Date])