counting rows on the date column where the time > 5:30 pm

[waleed55]

hi i want to counting rows on the date column where the time > 5:30 pm how can do that

[v-yangliu-msft]

Hi  @waleed55 ,

Here are the steps you can follow：

1. Create measure.

Flag =
IF(
MAX('Table'[Column1]) >
 DATE(YEAR(MAX('Table'[Column1])),MONTH(MAX('Table'[Column1])),DAY(MAX('Table'[Column1]))) + TIME(17,30,0),1,0)

Count =
COUNTX(
ALLSELECTED('Table'),[Flag])

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[waleed55]

hi i don't want to create a new column i want to create measure only

[Greg_Deckler]

@waleed55 So maybe something like this:

Column 2 = 
    VAR __530 = 1/24/2 * ( 17.5 * 2 )
    VAR __Value = [Column]
    VAR __Result = IF( __Value >= __530, 1, 0)
RETURN
    __Result