Forum Discussion
molzmad
Helper I
Helper IColumn reset every day
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
3 Replies
- amitchandak
Super User
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]))
molzmadhttps://drive.google.com/file/d/1-ZDrVOJ_hCI2Jzvlze2_7nMibnLSEZgX/view?usp=sharing
here ^ sorry should work now, ill try your suggestion 🙂
- molzmad
Do you know how i'd do it as a calculated column and not a measure ? 🙂
