Forum Discussion
Combine data and number column in Power Query
FYI that you can Ctrl click on your number and date columns to select them both, and then choose Remove Duplicates from the ribbon under Remove Rows. To concatenate them, they both need to be type text, so you'll need something like:
= Number.ToText([Number Column]) & " " & Date.ToText([Date Column], "yyyyMMMdd")
Pat
As sean_w said it is quite hard to give a straight answer without a little bit more of context. My suggestion would be to, prior to the combine step in the Query Editor, changing the type of the two columns to "type any" and then combining the two. After the combine is performed, changing back to "date" and "Int64.Type" (i guess its this type you have now) to maintain data consistency and quality.
Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!
Best regards,
Gonçalo Geraldes