Forum Discussion
Helper VSorty by Date and then ID
Hello everyone,
I have given the following situation:
This is sorted by date in descending order. As you can see, the ID on the left is not in chronological order.
| ID | Date |
| Customer Number | |
| 10 | 29.06.2022 00:00 | 12778 | ||
| 9 | 29.06.2022 11:17 | 80015 | ||
| 11 | 30.06.2022 00:00 | 11386 | ||
| 12 | 30.06.2022 00:00 | 11168 | ||
| 13 | 30.06.2022 00:00 | 11219 | ||
| 18 | 01.07.2022 00:00 | 12146 | ||
| 17 | 01.07.2022 00:00 | 11334 | ||
| 16 | 01.07.2022 00:00 | 11369 | ||
| 19 | 01.07.2022 00:00 | 12166 | ||
| 20 | 01.07.2022 00:00 | 12897 | ||
| 15 | 01.07.2022 00:00 | 11671 | ||
| 14 | 01.07.2022 00:00 | 11777 |
The date should still be in chronological order. When this is done, the ID should then expire chronologically.
This would be the result I then expect in Power BI...
| ID | Date |
| Customer Number | |
| 10 | 29.06.2022 00:00 | 12778 | ||
| 9 | 29.06.2022 11:17 | 80015 | ||
| 11 | 30.06.2022 00:00 | 11386 | ||
| 12 | 30.06.2022 00:00 | 11168 | ||
| 13 | 30.06.2022 00:00 | 11219 | ||
| 14 | 01.07.2022 00:00 | 11777 | ||
| 15 | 01.07.2022 00:00 | 11671 | ||
| 16 | 01.07.2022 00:00 | 11369 | ||
| 17 | 01.07.2022 00:00 | 11334 | ||
18 | 01.07.2022 00:00 | 12146 | ||
| 19 | 01.07.2022 00:00 | 12166 | ||
| 20 | 01.07.2022 00:00 | 12897 |
Does somebody has any idea?
I tried it with an index column, but I can sort either by date or by ID, unfortunately that didn't help me.
Hi azaterol ,
You can use Shift + Left Click on the column header to sort this accordingly.
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/
2 Replies
- jaideepnema
Solution Sage
Hi azaterol ,
You can use Shift + Left Click on the column header to sort this accordingly.
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/
- azaterol
jaideepnema Thank you.
