Forum Discussion
Receiving Cannot mix text with values error
It turns out you can sijmply use the formatting in the table view and with will apply that correct formatting to numerical outputs while leaving the texct outputs alone. I had assumed this would cause an error but it has not yet done so.
my god, I solved it. Even though there are text strings in the column I can set the formatting to percent without an error. The solution was so simple my brain hurts from it. I assumed the text strings would cause an error. No DAX modifications were needed to format the numbers. (face palm).
It turns out you can sijmply use the formatting in the table view and with will apply that correct formatting to numerical outputs while leaving the texct outputs alone. I had assumed this would cause an error but it has not yet done so.