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).
Hi, LYorkToenniges
I'm glad you solved the problem you were experiencing.
Can you please share your method and accept it as a solution? This will help other members of the community with problems similar to yours to be able to find a solution faster. Thank you very much!
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.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.