Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello! I need some help generating a sequence for orders that restarts each day. Currently I have a sequence column in my xlsx but it counts 1 to end of document. I would like the sequence to be based off of order times and restart each day.
Example of current state:
Sequence | Date | Order | Time |
1 | Feb 15 | A | 8:00 |
2 | Feb 15 | B | 8:01 |
3 | Feb 16 | C | 8:00 |
4 | Feb 17 | D | 8:00 |
Example of desired State:
Sequence | Date | Order | Time |
1 | Feb 15 | A | 8:00 |
2 | Feb 15 | B | 8:01 |
1 | Feb 16 | C | 8:00 |
1 | Feb 17 | D | 8:00 |
Thanks!
This is pretty close,
This is what I put for the new column
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |