Forum Discussion
DAX Question : Average Days between purchases
My averages seemed a little high so I decided to use the Median instead. Unfortunately, My powerpivot did not support it as DAX so I created this little gem:
(MINX (FILTER ( VALUES ( Customer[Days between] ),
CALCULATE (
COUNT ( Customer[Days between] ), Customer[Days between] <= EARLIER ( Customer[Days between] ) )
> COUNT ( Customer[Days between] ) / 2 ), Customer[Days between])
+ MINX ( FILTER ( VALUES ( Customer[Days between] ),
CALCULATE (
COUNT ( Customer[Days between] ), Customer[Days between] <= EARLIER ( Customer[Days between] ))
> ( COUNT ( Customer[Days between] ) - 1 ) / 2 ), Customer[Days between])) / 2I am posting this in hopes of helping someone else as I have now created my own very cumbersome answer. Maybe a shorter answer will present it self but for now I feel like my microphone is off.
(tap tap tap)"Is this thing on?"
My averages seemed a little high so I decided to use the Median instead. Unfortunately, My powerpivot did not support it as DAX so I created this little gem:
(MINX (FILTER ( VALUES ( Customer[Days between] ),
CALCULATE (
COUNT ( Customer[Days between] ), Customer[Days between] <= EARLIER ( Customer[Days between] ) )
> COUNT ( Customer[Days between] ) / 2 ), Customer[Days between])
+ MINX ( FILTER ( VALUES ( Customer[Days between] ),
CALCULATE (
COUNT ( Customer[Days between] ), Customer[Days between] <= EARLIER ( Customer[Days between] ))
> ( COUNT ( Customer[Days between] ) - 1 ) / 2 ), Customer[Days between])) / 2
I am posting this in hopes of helping someone else as I have now created my own very cumbersome answer. Maybe a shorter answer will present it self but for now I feel like my microphone is off.
(tap tap tap)"Is this thing on?"
Hello I didnt underestand ho to get Average days beteewn purchases.
But I got other question, how do i get the standar deviation of the days between purchases.
I have:
Date table
Purchases table,
Customer tables.
Thanks,