I need help with my formula TODAY()

[RvdHeijden]

I thought this one was easy but guess not 🙂

i have a colume with a dates in it and i want to know how many times TODAY() is used.

COUNTROWS(Verzuimverloop[datum ziektemelding]=TODAY())

Simply put i want to know how many people called in sick today, therefore i used TODAY() because obviously i want to know the exact same thing tomorrow and i dont want to change the date each and every time

[v-ljerr-msft]

Hi @RvdHeijden,

Have you tried the solution provided above? It should work in your scenario. If you still have any question, feel free to post it here.

Regards

[RvdHeijden]

Thanks for the reminder, i have a few posts on this forum and forgot to close this one.

That formula did the trick

[Vvelarde · Accepted solution]

@RvdHeijden

Hi, 

try using this measure:

CallsToday = COUNTROWS(FILTER(Verzuimverloop,Verzuimverloop[datum ziektemelding]=TODAY()))

Let me know if works on your side.