cancel
Showing results for
Did you mean:
Highlighted
Helper V

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion

## Re: Count days between first two dates in same column for same user

@Yggdrasill

``````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 🙂

2 REPLIES 2
Highlighted
Community Champion

## Re: Count days between first two dates in same column for same user

@Yggdrasill

``````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 🙂

Highlighted
Helper V

## Re: Count days between first two dates in same column for same user

You absolute beauty ! Thank you !

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021