cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
grafvont Frequent Visitor
Frequent Visitor

Calculate average interval time between transactions

Dears,

 

I have to calculate the average time between multiple transactions of same accounts, how it can be done with DAX? 

 

2019-01-18_14-17-20.jpg

 

 

Thank you for your support!!!!

Bests,
T

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Calculate average interval time between transactions

Probably easiest to create a column using EARLIER and DATEDIFF. See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


2 REPLIES 2
Super User
Super User

Re: Calculate average interval time between transactions

Probably easiest to create a column using EARLIER and DATEDIFF. See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


grafvont Frequent Visitor
Frequent Visitor

Re: Calculate average interval time between transactions

Thank you Greg!