Frequency Measure

[rogerdea]

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]

amazing, thanks so much 

[amitchandak · Accepted solution]

@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)