Hi there,
Forgive me if this has already been solved but I cant find a solve that is working for me.
I have a table of date times like this:
| Start Time | Time of Max |
| 01/01/2020 00.00 | |
| 01/01/2020 03.00 | |
| 01/01/2020 06.00 | |
| 01/01/2020 09.00 | |
| 01/01/2020 12.00 | 01/01/2020 12.00 |
| 01/01/2020 15.00 | |
| 01/01/2020 18.00 | |
| 01/01/2020 21.00 | |
| 02/01/2020 00.00 | |
| 02/01/2020 00.00 | |
| 02/01/2020 03.00 | |
| 02/01/2020 06.00 | |
| 02/01/2020 09.00 | |
| 02/01/2020 12.00 | |
| 02/01/2020 15.00 | |
| 02/01/2020 18.00 | |
| 02/01/2020 21.00 | 02/01/2020 21.00 |
| 03/01/2020 00.00 | |
But I want it to add a column like this:
| Start Time | Time of Max | Time of Max (2) |
| 01/01/2020 00.00 | | |
| 01/01/2020 03.00 | | |
| 01/01/2020 06.00 | | |
| 01/01/2020 09.00 | | |
| 01/01/2020 12.00 | 01/01/2020 12.00 | 01/01/2020 12.00 |
| 01/01/2020 15.00 | | 01/01/2020 12.00 |
| 01/01/2020 18.00 | | 01/01/2020 12.00 |
| 01/01/2020 21.00 | | 01/01/2020 12.00 |
| 02/01/2020 00.00 | | 01/01/2020 12.00 |
| 02/01/2020 00.00 | | 01/01/2020 12.00 |
| 02/01/2020 03.00 | | 01/01/2020 12.00 |
| 02/01/2020 06.00 | | 01/01/2020 12.00 |
| 02/01/2020 09.00 | | 01/01/2020 12.00 |
| 02/01/2020 12.00 | | 01/01/2020 12.00 |
| 02/01/2020 15.00 | | 01/01/2020 12.00 |
| 02/01/2020 18.00 | | 01/01/2020 12.00 |
| 02/01/2020 21.00 | 02/01/2020 21.00 | 02/01/2020 21.00 |
| 03/01/2020 00.00 | | 02/01/2020 21.00 |
I need it to be a DAX query too.
