Date Issues when Creating a Join

[Razorbx13]

Is there a way to NOT HAVE the date change when I concantenate two fields?  I am creating a key of employee number and a date.  The date looks fine below on the right hand side, but when I create the KEY field, the date changes to YYYY-MM-DD.  It needs to stay as MM/DD/YYYY so it can used as a join to another table.  This is a direct query table to be joined to another direct query table.

TIA!

[v-alq-msft · Accepted solution]

Hi, @Razorbx13 

Based on your description, I created data to reproduce your scenario.

Then you may create a calculated columns as follows.

NewColumn = 
'Table'[ID]&"-"&FORMAT('Table'[Date],"yyyy-MM-dd")

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VasTg]

@Razorbx13 

Create a new Custom Column in Query editor with this formula.

=Text.From([Column1]) & Text.From([Column2])

If this helps, mark it as a solution

Kudos are nice too

[Razorbx13]

Close, but my date still comes out as YYYY-MM-DD.  See below.  Trying to get XXXX-MM/DD/YYYY

[VasTg]

@Razorbx13 

Is your 1st Date column is in MM/DD/YYYY date format? What's your source?

Can't you just convert the MM/DD/YYYY to YYYYMMDD numeric format and concatenate?

=Date.ToText([Date1],"YYYYMMDD") & Text.From([Emp])

If this helps mark it as a solution

Kudos are nice too