Reply
Highlighted
Frequent Visitor
Posts: 2
Registered: ‎01-18-2019
Accepted Solution

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


Accepted Solutions
Super User
Posts: 10,462
Registered: ‎07-11-2015

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!


View solution in original post


All Replies
Super User
Posts: 10,462
Registered: ‎07-11-2015

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!


Frequent Visitor
Posts: 2
Registered: ‎01-18-2019

Re: Calculate average interval time between transactions

Thank you Greg!