Evaluating Max of text column converted to number

[Anonymous]

I would like to format my Reporting Month Number as type String / Text so that it does not auto-aggregate eg sum when it is dragged into a visual.

But my time intelligence formulas are reliant on this column being formatted as data type number.

See below measure expression as an example. It won't evaluate because in the highlighted section it is comparing a column that is now text to a number. 

I have tried in the below example to convert the column for the purpose of the measure from text to number using the VALUE function, but I am getting an error that says "MAX function only accepts a column reference as argument".

How/which function can I use in my measure for this to evaluate with Reporting Month Number as type String / Text? 

[johnt75]

Instead of converting to text just change the summarize property to "don't summarize".

[Anonymous · Accepted solution]

Thank you