Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
19
Views
Topic starter
Hi all:
I am getting errors on combining [Sweep Count] & "Day".
[Sweep Count] column is a number from 2 to 7. I want my custom column to display 2 Day ...7 Day
Its driving me crazy, nothing seems work.
Thanks
Robb
Posted : 03/02/2021 3:56 am
Most probably, the error says something like: "Cannot combine text and numbers"
You have to make sure the data type is the same (text), basically this is what it means...
Text.From([Sweep Count]) & "Day"
Posted : 03/02/2021 4:11 am