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.