Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi, I am trying to add an incremental 5 minutes to each row in the power query.
Please see the data and expected output below:
| Date Time | Output |
| 16/12/2023 8:35:00 PM +10:00 | 16/12/2023 8:35:00 PM +10:00 |
| 16/12/2023 8:35:00 PM +10:00 | 16/12/2023 8:40:00 PM +10:00 |
| 16/12/2023 8:35:00 PM +10:00 | 16/12/2023 8:45:00 PM +10:00 |
| 16/12/2023 8:35:00 PM +10:00 | 16/12/2023 8:50:00 PM +10:00 |
| 17/12/2023 12:15:00 PM +10:00 | 17/12/2023 12:15:00 PM +10:00 |
| 17/12/2023 12:15:00 PM +10:00 | 17/12/2023 12:20:00 PM +10:00 |
| 17/12/2023 12:15:00 PM +10:00 | 17/12/2023 12:25:00 PM +10:00 |
TIA
Solved! Go to Solution.
pls try this
@Ahmedx thank you for your replay,
but the expected output is a bit different.
for example, if the data for the day starts with
Row 1 -- 16/12/2023 8:35:00 PM
Row 2 -- 16/12/2023 8:40:00 PM
Row 3 -- 16/12/2023 8:45:00 PM
Row 4 -- 16/12/2023 8:50:00 PM
Perfect..! Thank you.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 98 | |
| 72 | |
| 50 | |
| 49 | |
| 44 |