Forum Discussion

MrTechie's avatar
MrTechie
Frequent Visitor
2 years ago
Solved

Incremental Minutes for each row in Power Query

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:...
Need Help
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

pls try this

MrTechie's avatar
MrTechie
Frequent Visitor
2 years ago

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

 

    • MrTechie's avatar
      MrTechie
      Frequent Visitor
      2 years ago

      Perfect..! Thank you.