DAX calculated column add text at the end

[Anonymous]

Hello,

I have the following calculated column formula which calculates the difference between two dates and i use it in a table visualization with the start date, end date and duration columns. But i want to add a text at the end of the duration value: " days".

Duration = DATEDIFF('Scores'[Start date],'Scores'[End date],DAY)+1

I tried to use the concatenate function but it does not work. Any help is much appreciated!

Duration = CONCATENATE((DATEDIFF('Scores'[Start date],'Scores'[End date],DAY)+1), " days")

[jdbuchanan71 · Accepted solution]

@Anonymous 

Try this.

Duration = DATEDIFF('Scores'[Start date],'Scores'[End date],DAY)+1 & " days"