How to display dates without todays date?

[evadung]

Hello, 

I have a calendar table wheres date, year, month, day and I want a column that shows what days are past = 0 and todays day = 1.

I have this formulas: 

1) IsCurrentDay = IF(AND(DAY(Kalender[Datum])=DAY(TODAY()), MONTH(Kalender[Datum])=MONTH(NOW())),1,0)

 This formula shows date for ex. 10.1.2023 as 1, for other years with same date but another year also marked as 1. 

2) IsCurrentDay = IF(AND(DAY(Kalender[Datum])=DAY(TODAY()), YEAR(Kalender[Datum])=YEAR(NOW())),1,0)

This formula shows date for ex. 10.1.2023 and 10.2.2023 as 1. But I want just date 10.2.2023 to be marked as 1.

I tried this one: 

IsCurrentDay = IF(AND(DAY(Kalender[Datum])=DAY(TODAY()), MONTH(Kalender[Datum])=MONTH(NOW()), YEAR(Kalender[Datum])=YEAR(NOW())),1,0)

but function AND allows only 2 arguments.

Is there any other options? Thank you

[johnt75 · Accepted solution]

You can add a column like

Is Current Day =
IF ( Kalender[Datum] = TODAY (), 1, 0 )

[evadung]

It works. Thank you!