Forum Discussion

arsm's avatar
arsm
Frequent Visitor
2 years ago
Solved

Create a list from two timestamps in power query

Hello, I'm trying to create a list from two timestamp columns in power query  I have two columns with date and hour  Column 1                                           Column 2  12/14/2023 10:00:0...
data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi arsm ,

    Please change the M function into this:

    Table.AddColumn(#"Changed Type", "Custom.1", each List.DateTimes([Column1], Duration.TotalHours([Column2] - [Column1]) + 1 ,#duration(0,1,0,0)))


    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi arsm ,

jennratten Thanks for your reply!

arsm Just change the answer of jennratten 's into:

= Table.AddColumn(#"Changed Type", "Custom", each List.DateTimes([Column1], Number.From([Column2]) ,#duration(0,1,0,0)))


Best Regards,
Dino Tao
If this post helps, then please consider Accept both of the answers as the solution to help the other members find it more quickly.

arsm's avatar
arsm
Frequent Visitor
2 years ago

Anonymous  Thank you for replying 

I was able to create a list but list wont stop at 12/15/2024 1:0:0 PM (column 2), it keeps going. 

how can i end the list at column 2 timestamp 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi arsm ,

    Please change the M function into this:

    Table.AddColumn(#"Changed Type", "Custom.1", each List.DateTimes([Column1], Duration.TotalHours([Column2] - [Column1]) + 1 ,#duration(0,1,0,0)))


    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.