Forum Discussion
carol_mar
Helper I
Helper Idate
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.
carol_marHelper I
Helper Ino, it doesn't work, gives me error
amitchandak
Super User
Super Userwhich solution you tried and what error you got.
- carol_mar
😪
this one, why??
- amitchandak
One ) should be before ;Day
- carol_mar
yes sorry, but still it gives all 0