Forum Discussion
axk180022
Helper II
Helper IIFind the latest 2 dates
Expected output CALCULATIONDATETIME INVNETSERIALID GENERATORHOURS 9/25/2020 CVS-002 8154 11/23/2020 CVS-002 8359 5/13/2021 CVS-003 9122 5/27/2021 CVS-003 9159 ...
axk180022 and here is the output:
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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.⚡
axk180022CALLACTIONDATETIME INVENTSERIALID GENERATORHOURS 6/23/2020 14:55 CVS-002 2600 6/24/2020 12:31 CVS-002 7749 6/25/2020 17:32 CVS-002 7749 7/28/2020 13:10 CVS-002 7749 8/19/2020 18:30 CVS-002 0 8/31/2020 13:15 CVS-002 0 9/19/2020 14:00 CVS-002 8103 9/25/2020 21:30 CVS-002 8154 11/18/2020 17:00 CVS-002 0 11/23/2020 19:40 CVS-002 8359 12/16/2020 13:30 CVS-003 8479 3/9/2021 16:43 CVS-003 8804 4/27/2021 21:55 CVS-003 5107 5/13/2021 15:41 CVS-003 9122 5/27/2021 14:00 CVS-003 9159 6/16/2021 19:07 CVS-003 0