Need to calculate revenue for unconventional business day (hours are 4:00am - 3:59am).

[Fulfilled]

I am experiencing an issue when trying to calculate the revenue for a given business day.  Here is an example of what timeframe constitutes a business day:

8/7/2022 4:00am - 8/8/2022 3:59AM - This would be for business day 8/7/2022.

The data i am working with is all labeled by calendar day.  The data also has a column for hour which i believe should prove to be helpful.  My issue is that i do not know how to manipulate my DAX to give me the revenue for my business day and label it with the correct day.

Here is an example of the data i am working with:

Here is the query i am using which works if my business day aligned with the calendar day:

Coin In Sum By Date (Calendar) = CALCULATE(SUM('Headcount SP Data'[Coin In Sum By Hour]), ALLEXCEPT('Headcount SP Data','Headcount SP Data'[dtTime]))

Is it possible to produce the data that would say:

Coin In Sum By Date (Business) = SUM of Coin In Sum By Hour WHERE iHour = 4-24 on Day 1 and 0-3 on Day 2

(All while tagging this result as Day 1)

[amitchandak]

@Fulfilled , Refer if this blog can help

https://exceleratorbi.com.au/calculating-business-hours-using-dax/