Forum Discussion
Helper IVFrequency Measure
I'm trying to calculate the frequency of date/times in a table and struggling to figure it out (even reading similar posts).
I am wanting a measure which is the average amount of time (in minutes) between date/times. So for example the measure would tell me an event occurs every X minutes on average. I have a data table named "data" and date table attached to it.
Can anyone show me how this would be done from this data below, unfortunately i cannot upload the pbx or link to a cloud drive.
rogerdea , You need to create a new column and take diff
Create a new column =
datediff(Maxx(filter(Table, [Datetime] < earlier([date time]) ), [date time]) , [Date time], second)
2 Replies
- amitchandak
Super User
rogerdea , You need to create a new column and take diff
Create a new column =
datediff(Maxx(filter(Table, [Datetime] < earlier([date time]) ), [date time]) , [Date time], second)
rogerdeaamazing, thanks so much