Column reset every day

[molzmad]

Hi,
im looking to reset the occupancy 2 column every day based on the timenew column, so everyday the accumulative count restarts from zero, 

i have attached the file :),

any help would be greatly appreciated
https://drive.google.com/file/d/1-ZDrVOJ_hCI2Jzvlze2_7nMibnLSEZgX/view?usp=sharing 

[molzmad]

Do you know how i'd do it as a calculated column and not a measure ? 🙂

[amitchandak]

@molzmad , requested access on the file.

Based on assumption

if you have datetime

new column

date =[datetime].date

measure

calculate(countrows(Table), filter(allselected), [Datetime]<=max([Datetime]) && [Date] = max([Date]))

[molzmad]

https://drive.google.com/file/d/1-ZDrVOJ_hCI2Jzvlze2_7nMibnLSEZgX/view?usp=sharing

here ^ sorry should work now, ill try your suggestion 🙂