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
Greg_Deckler
Community Champion
Community ChampionProbably 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
Thank you Greg!