count of orders on n hour basis - Power BI

Question

How to find the count of orders in past 12 hours?

Answer 1

Hi Nithin,

You can create a measure to find those dates for find difference as datediff([date],today(),hour) and then compare as if(datediff([date],today(),hour) <12, "12 hr","past"). Now use calculate and calculate count(order) and filter as 12 hr.

Hope it helps you.