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.
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.
How did you expand something? Can you share a sample?
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.
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")
Could you please mark the proper answers as solutions?