I'm trying to create a label that will show the following: MP 23.6 The "23.6" is a double type column in my table, the "MP" is the text I want to add in front of it of the number (milepost).
I am new to QGIS.
You are trying to perform an addition between a string and a number. Instead, use the ||
evaluator which will concatenate both into a string like so:
'MP' || "Milepost"
You could also transform the value of your Milepost
field to a string in your expression as in this question/answer.