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
PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi Anonymous 

I'm a bit confused.  You've posted in he Power Query forum but you are referring to a Calculated Column which is what you get in DAX/Power Pivot.  Are you looking for a solution in DAX?  You use Custom Columns in Power Query.

Why do you need to add 8 new columns?  Why aren't you splitting your source columns into just 2 columns, one for date and one for time?

Can you please share soem source data and the expected outcome so we know what we are aiming to produce.

regards

Phil

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I'm posting here beauase there is no Tabular Model / DAX board here...and I've had other questions on DAX answered here.

    I need to have three columns: the original column which is a datetime, a column to hold the date, and a column to hold the time, so I am trying to do just what you said.

    So essntially if you have 11/01/2020 10:00:00, you would then have 11/01/2020 in one column and 10:00:00 in a third.