Compare Dates, Hour, Minute between two Data set and return Value

Hi Anonymous 

I get a result table as below ( filter [Hour] <=5 and [Date] =2019/1/1, so that it displays more clearly)

If it meets your requirement, please refer to the steps below

1. In Edit queries, in "Date" table, Add two custom column

Custom=#"Hour"

Custom.1=#"Minute"

then expand two custom columns

2.

In "Date" table,

select "Date", 'Custom.Hour", "Custom.1.Minute" , then "Add column"->Merge column(Separator is "-" in my example)

Then in "Actual Source Table", 

select "Date", 'Hour", "Minute" , then "Add column"->Merge column(Separator is "-" too)

3.

In "Date" table, merge queries, then expand "Merged 2" column from "Source table"

4. Close&&apply, create a cacluated column

count = CALCULATE(COUNTROWS('Date'),FILTER(ALLEXCEPT('Date','Date'[Date]),[Actual Source Table.Merged2]<>BLANK()))

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.