daily production

[dqG9kYbAmF7tfNx]

can you please help me create a dax for calculating the sum of the daily production where my day starts at 5:00 am, and ends at 5:00am next day. also ny weekly production starts 5:00 am Sunday to 5:00 am sunday of the next week.

in other words, my day starts at 5:00 am not 12:00 am

[v-qiuyu-msft · Accepted solution]

Hi @dqG9kYbAmF7tfNx, 

You can create two calculated columns like below: 

NewDateTime = Table1[DateTime]-5/24
NewDate = Table1[NewDateTime].[Date]

Then create a measure: 

Measure 4 = CALCULATE(SUM(Table1[Amount]),FILTER(ALL('Table1'),Table1[NewDate]=MAX(Table1[NewDate])))

Best Regards,
Qiuyun Yu 

[dqG9kYbAmF7tfNx]

Thank you, this is amazing. I still don't know much how it works