Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.