Forum Discussion
Yggdrasill
Responsive Resident
Responsive ResidentCount 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.20...
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 🙂
Fowmy
Super User
Super UserYggdrasill
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 🙂
- YggdrasillYou absolute beauty ! Thank you !
