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.⚡
axk180022Helper II
Helper II| CALLACTIONDATETIME | 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 |