Forum Discussion

PowerBI_Noob90's avatar
PowerBI_Noob90
Frequent Visitor
3 years ago

Combining Text & Date in Power Query

I'm using Power Query to combine a text column with a date column (I use [Text Column]&" "&[Date Column]) and am getting an error message that says I can't combine & and a column with a date format. ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Try

 

[Text Column]&" "&Date.ToText([Date Column]))

 

--Nate