Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. let
  2. Source = {0..23},
  3. #"Converted to Table" = Table.FromList(
  4. Source, Splitter.SplitByNothing(),
  5. {"Index"}, null, ExtraValues.Error
  6. ),
  7. #"Changed Type" = Table.TransformColumnTypes(
  8. #"Converted to Table",
  9. {{"Index", Int64.Type}}
  10. ),
  11. #"Added Custom" = Table.AddColumn(
  12. #"Changed Type", "Hour",
  13. each #time([Index], 0, 0),
  14. Time.Type
  15. )
  16. in
  17. #"Added Custom"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement