Concatenate/& lose formats

[curiouspbix0]

Concatenating date fields along with time and text fields using "&" or other functions do not hold the set format of the date or time  leaving it to power query default format.

Any tips without having to create additional fields in DAX or Power Query just for formatting to work.

[AllisonKennedy · Accepted solution]

I would recommend having a really robust Date table with all the fields in the formats you require, but if you are wanting to avoid creating extra fields, you can try the FORMAT function inside the concatanated & DAX statements. 

Mark this as solution if this solves your problem, otherwise, if you can provide more concrete examples of what you mean the community might be able to provide other solutions. 

[parry2k]

@curiouspbix0 here is what you can use for formatting

Date and Time Column = 
FORMAT( Table[DateColumn], "MM/DD/YYYY" ) & " " & FORMAT( Table(TimeColumne", "hh:mm:ss" )

Read more about Format function here

Read more about the pre-define date and time format here

Read more about the custom date and time format here

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!