cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
RvdHeijden Member
Member

I need help with my formula TODAY()

I thought this one was easy but guess not Smiley Happy

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: I need help with my formula TODAY()

@RvdHeijden

 

Hi, 

 

try using this measure:

 

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

 

Let me know if works on your side.




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




3 REPLIES 3
Super User
Super User

Re: I need help with my formula TODAY()

@RvdHeijden

 

Hi, 

 

try using this measure:

 

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

 

Let me know if works on your side.




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




v-ljerr-msft Super Contributor
Super Contributor

Re: I need help with my formula TODAY()

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.Smiley Happy

 

Regards

RvdHeijden Member
Member

Re: I need help with my formula TODAY()

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

That formula did the trick