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.
Hi,
I have a table generated from SQL that looks like this
ts_start | ts_end | unit | Number | reason |
1/11/2021 0:00 | 1/11/2021 10:42 | X100 | 5000 | |
1/11/2021 10:42 | 2/11/2021 0:00 | X100 | 0 | X |
1/11/2021 0:00 | 1/11/2021 10:41 | X200 | 5000 | |
1/11/2021 10:41 | 2/11/2021 0:00 | X200 | 0 | X |
1/11/2021 0:00 | 1/11/2021 10:26 | X300 | 5000 | |
1/11/2021 10:26 | 2/11/2021 0:00 | X300 | 0 | X |
2/11/2021 0:00 | 3/11/2021 0:00 | X100 | 0 | X |
2/11/2021 0:00 | 2/11/2021 10:10 | X200 | 0 | X |
2/11/2021 10:10 | 2/11/2021 14:20 | X200 | 2500 | Y |
2/11/2021 14:20 | 3/11/2021 0:00 | X200 | 5000 | |
2/11/2021 0:00 | 3/11/2021 0:00 | X300 | 0 | X |
3/11/2021 0:00 | 4/11/2021 0:00 | X100 | 0 | X |
3/11/2021 0:00 | 4/11/2021 0:00 | X200 | 5000 | |
3/11/2021 0:00 | 3/11/2021 14:52 | X300 | 0 | X |
3/11/2021 14:52 | 3/11/2021 17:10 | X300 | 2500 | Y |
3/11/2021 17:10 | 4/11/2021 0:00 | X300 | 1000 | Y |
4/11/2021 0:00 | 5/11/2021 0:00 | X100 | 5000 | |
4/11/2021 0:00 | 5/11/2021 0:00 | X200 | 5000 | |
4/11/2021 0:00 | 5/11/2021 0:00 | X300 | 5000 |
Looking for solutions to combine multiple rows within the same day into a single row into something like below, is this doable using power query?
Thank you.
Solved! Go to Solution.
It works! Thanks a lot! 🙂
Check out the July 2025 Power BI update to learn about new features.