cancel
Showing results for
Did you mean:
Highlighted
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 =
VAR ThisHour =
HOUR( NOW ())
RETURN
IF ( ThisHour = NotifcationHour, "yes", "no" )
1 ACCEPTED SOLUTION

Accepted Solutions
Super User

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

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

Create a New Measure as below to count the CurrentHourFlag

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

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

Proud to be a Datanaut !

Super User

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

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

Create a New Measure as below to count the CurrentHourFlag

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

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

Proud to be a Datanaut !