Calculate days between earliest startdate and latest enddate

[Anonymous]

Hello community members, 

It looks simple but I just can't get the right formula's. I have the following 2 questions:

Each client is an unique person with a unique healthcare track. This track can be a 'one time' track (just 1 row) or more short tracks (multiple rows).

When the track is only one row, it is simple, but with multiple rows for one client, I don't know how to make the correct formula to define the number of days between the earliest StartDate and the latest EndDate per client

Client	StartDate	EndDate
fd12f1asd21f3sd	1-1-2021	31-1-2021
fd12f1asd21f3sd	7-2-2021	15-3-2021
fd12f1asd21f3sd	1-5-2021	31-5-2021
fd12f1asd21f3sd	1-6-2021	15-6-2021
rer5e6r56err65q	15-2-2021	31-3-2021
qe6r5e6re1re2qr	1-1-2021	31-1-2021

Hope to hear soon from you. 

Best regards, 

Sander

[parry2k · Accepted solution]

@Anonymous here is what you can do to get first and last date for each client regardless of number of records per client:

Earliest Date = CALCULATE ( MIN ( Table[Date] ), ALLEXCEPT ( Table, Table[Client] ) )

Latest Date = CALCULATE ( MAX( Table[Date] ), ALLEXCEPT ( Table, Table[Client] ) )

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

@parry2k thanks for your help!