Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
RvdHeijden
Post Prodigy
Post Prodigy

I need help with my formula TODAY()

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

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@RvdHeijden

 

Hi, 

 

try using this measure:

 

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

 

Let me know if works on your side.




Lima - Peru

View solution in original post

3 REPLIES 3
v-ljerr-msft
Employee
Employee

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

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

That formula did the trick

Vvelarde
Community Champion
Community Champion

@RvdHeijden

 

Hi, 

 

try using this measure:

 

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

 

Let me know if works on your side.




Lima - Peru

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.