calculating number of orders between two timings

[lawada]

im trying to calculate the orders that are placed between 10:00 PM and 8:00 AM using the hour function however im getting a blank value . 

can someone help me with this 

[amitchandak]

@lawada , It need to be OR (|| )

calculate(count(Orders[Order_id]), filter(Orders,hour(orders[placed order date]) >=22 || hour(orders[placed order date]) < 8))

[Fowmy]

@lawada 

Try this measure please:

Later Order10 = 

CALCULATE(
    COUNTROWS( Table01 ),
        var __hour = HOUR(Table01[Placed Order Date]) return
        __hour >= 22 || __hour < 8
    
)

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn