cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abehrmann1 Frequent Visitor
Frequent Visitor

Help!!!! Deadline approaching!! Formula to identify the current hour

I am attempting to use this calculated column as a filter so i can use it conjuction with a similar formula for "count today" 
 
the "Count today" is working but "is this hour" work with it. Any suggestions?
 
Count Today =
CALCULATE ( [Count of ID],'Date'[Date]=TODAY() )
 
IS This Hour =
VAR NotifcationHour =
HOUR( NotificationData[Notification_Time] )
VAR ThisHour =
HOUR( NOW ())
RETURN
IF ( ThisHour = NotifcationHour, "yes", "no" )
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Help!!!! Deadline approaching!! Formula to identify the current hour

@abehrmann1 Can't see any issue with your formula...

 

image.png

 

Create a New Measure as below to count the CurrentHourFlag

 

Test259 = COUNTX(FILTER(Test259CurrHour,Test259CurrHour[CurrentHourFlag]="Yes"),Test259CurrHour[CurrentHourFlag])

image.png



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

Proud to be a Datanaut !





1 REPLY 1
Super User
Super User

Re: Help!!!! Deadline approaching!! Formula to identify the current hour

@abehrmann1 Can't see any issue with your formula...

 

image.png

 

Create a New Measure as below to count the CurrentHourFlag

 

Test259 = COUNTX(FILTER(Test259CurrHour,Test259CurrHour[CurrentHourFlag]="Yes"),Test259CurrHour[CurrentHourFlag])

image.png



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

Proud to be a Datanaut !