Forum Discussion
Solved
Transaction Gaps
Hey, I need help in creating below DAX. We need to calculate the transaction gap between all transactions for each customer. The maximum transactions gap is the longest a customer has gone betwe...
For fun only, Excel worksheet formulas are powerful enough,
You could create a measure like
Max gap =
var summaryTable = ADDCOLUMNS( SUMMARIZE( 'data', 'data'[Customer Name], 'data'[Product]),
"@val", [Transaction Gap])
return MAXX( summaryTable, [@val])You can do the same with AVERAGEX