Count if date greater than specific date

fs_ — Mon, 20 Jun 2022 11:21:48 GMT

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.

Re: Count if date greater than specific date

fs_ — Tue, 21 Jun 2022 07:26:33 GMT

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])