Forum Discussion
Solved
date
Hello, I need to manage some date. I need to calculate the difference (in terms o number days) among dates. so, I have for each costumer the date related to each transaction they make and I need...
Hi carol_mar ,
//Measures number of transaction = COUNT(Sheet7[transaction amount]) days in between = VAR x = MAX(Sheet7[date]) VAR y = MIN(Sheet7[date]) RETURN DATEDIFF(y,x,DAY)You must add [costumer id] column into the table chart or the matrix chart, doing this is equivalent to using ALLEXCEPT() function.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
😪
this one, why??
One ) should be before ;Day
yes sorry, but still it gives all 0
one correct , one is max, and you need view data by client'
days diff =
datediff(MIN(Table[date]),MAX(Table[date]), DAY)and now.. 30 everywhere😪