How to show Max quarter year count

[Lucky1]

Hi

I have created quarteryear by using below code

'Q' & ceil(month([Close of Business Date])/3) & '-' & Year(Date([Close of Business Date], 'YYYY')) as QuarterYear,

i want to create one measure showing max quarteryear sales.i have created one variable for max sales like

vmaxsales=max(Quarteryear) but some how it is not giving any value.

i want to show maximum quarter sales and previous quarteryear sales in a table how to do that

[BrunPierre]

Hi, Doesn't the expression "=MaxString(QuarterField)" return the most recent quarter year?