How to find player award status monthly basis period to period like improvement or steady

[Naps_230]

i have sample data below:

Player	award	month
A	gold	Jan
A	silver	Feb
B	silver	Jan
B	silver	Feb

I want to compare awards from one period to other period,
i need to check who is improved from Silver to gold
who stayed with gold with selected periods.

Here A status is improvement and B is Steady
Period should be dynamically.

[Or]

Since 'gold' and 'silver' don't actually compare - they're just strings of text - I'm translating them into 1 and 2 for this. If you want to write this out with text strings you can do that, it just gets kind of ugly.

Dimension: Player

Measure:

If(FirstSortedValue(award, month)<FirstSortedValue(award,-month),'Improvement','No improvement')

[Naps_230]

expression is showing error, i used 1 for Gold and 2 for silver, still get error 

[Naps_230]

i giving correct sample data again

Player	award	month
A	silver	Jan
A	gold	Feb
B	silver	Jan
B	silver	Feb

[Naps_230]

Hi All, Could you please update on that.

[Or]

This formula works fine - I tested it on my end...

Confirm that you have numeric values in both the award and month fields. As with "Gold" and "Silver", "Jan" and "Feb" are just text strings and there's no way to sort out which is bigger (other than string comparison, which is wrong because J > F)