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
Icon for Super User rankSuper User
5 years ago

Hi Anonymous 

Sample PBIX file here.

This will give you the Date column

 

Date = LEFT('Table'[DepartureDateTime], 10)

 

This will give you the Time column 

 

Time = MID('Table'[DepartureDateTime], 12, LEN('Table'[DepartureDateTime] - 12))

 

 To give

Modify the format to suit.

Regards

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.