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.
All I can see is that you seem to to have a date column as the single parameter in the calculate filter parameter position. I'm not sure what that's trying to do, but you can't do it that way. Maybe wrap the date column inside LASTDATE()
That actually works in other places I've used it. This is a modification of another measure that requires it to keep the calculations from summing over multiple dates, at least that seems to be how it's working. Maybe it's doing nothing and I'm going crazy, this is also possible.