Expand function changes date format

[Anonymous]

I have two tables that I need to link by date and serial number.  I have created a custom column that concatenates the two fields together.  Since one field is date field my concatenation is I created a new column for the date field that was text only.  The resulting field works fine:

After the expand the date format has changed:

Has anyone else seen this issue?  I've tried all the formatting options and nothing solves the problem.

Thanks,

Mark

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[v-jiascu-msft]

Hi @Anonymous,

How did you expand something? Can you share a sample?

Best Regards,
Dale

[Anonymous]

I had a merge query add a couple of fields from one database table another.  Once the merge was done I had to expand the merged table and select the fields I wanted added to my original data.

I hope this helps.  Let me know if I haven't answered your question.

Cheers,

Mark

[v-jiascu-msft]

Hi Mark,

Can you share a sample file that can show up the issue? According to my test and your information here, it should work. 

Please download the demo in the attachment. I would suggest you format the [Faild] column first.

[text] & "-" & Text.From([textdate], "en-us")

Best Regards,
Dale

[MFelix]

Hi @Anonymous,

I can't replicate the issue on my computer, check if have any Changed Type step on your query that is maing that transformation after the expanding or just before.

Regards,

MFelix