Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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/
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/
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |