Count days between first two dates in same column for same user

[Yggdrasill]

Hi ! Been struggling with this and I can't get this to work How can I achieve the last column ? 

id	user	trx date	dates between 1st and 2nd trx date
1	1	1.1.2020
2	12	1.1.2020
3	12	2.2.2020	32
4	47	3.3.2020
5	47	3.3.2020	0
6	2	4.4.2020
7	12	5.5.2020

As a calculated column I'm using functions like EARLIER() but with no success

Thank you

[Fowmy · Accepted solution]

@Yggdrasill 

Add this as a column to your table:

DaysDiff = 
VAR __USER = [user] RETURN
VAR __MIN = 
MINX(
    CALCULATETABLE(
        TOPN(2, Table1, Table1[trx date], ASC ),
        ALLEXCEPT(Table1,Table1[user])),
     Table1[trx date]
)
VAR __MAX = 
MAXX(
    CALCULATETABLE(
        TOPN(2, Table1, Table1[trx date], ASC ),
        ALLEXCEPT(Table1,Table1[user])),
     Table1[trx date]
)
RETURN
IF(
    [trx date] = __MAX, DATEDIFF( __MIN, __MAX, DAY)
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Yggdrasill]

You absolute beauty ! Thank you !