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
Without seeing the data types, how you're trying to combine the data, and the error, this is a bit of a shot in the dark. Given you're dealing with two different data types, it's likely that you're attempting to use a function that doesn't handle the data types. Here are a couple resources that might be helpful:
Power Query Merge Columns help article:
https://support.microsoft.com/en-us/office/merge-columns-power-query-80ec9e1e-1eb6-4048-b500-d5d42d9f0a8d
Power Query Function references:
https://docs.microsoft.com/en-us/powerquery-m/number-totext
https://docs.microsoft.com/en-us/powerquery-m/date-totext
Hi Sean,
Thanks for the feedback - mahoneypat has managed to provide a solution 😊
