Forum Discussion
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?
Thank you for your support!!!!
Bests,
T
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/339586
2 Replies
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/339586