Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Separate Date and Time From Timestamp in Calculated Column

I apologize in advance if this question has been aked before, but I've looked around and can't find the anwser that quite addresses my issue... I have a table in a tabula model with several datetime...
Need Help
CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

Hi, Anonymous , you might want to add new columns this way,

#"Added DateDeparture" = Table.AddColumn(Source, "DateDeparture", each Date.From(DateTime.FromText([DepartureDateTime]))),

#"Added TimeDeparture" = Table.AddColumn(#"Added DateDeparture", "TimeDeparture", each Time.From(DateTime.FromText([DepartureDateTime])))

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for the reply!

    The issue withthis is that I am actually needing to add eight new columns, and a calculated column strikes me as the easier route, without having to go in and rewrite the entire table expression.

    Also, there are several oter tables that will need this change, and if I have a "standard" calculation I can just modify based on input column, so much the easier!