Need Help

[paulwalker]

Hi Community,

I have one issue in Expression Label..

In my bar chart comparing Current month and Previous Month data.

in label i have used Max(Month) but it showing Number... I want to show Month name..

based on selection i want to change...

Thanks in advance..............

[settu_periasamy · Accepted solution]

Hi,

like the below snapshot.

PFA.

[paulwalker]

I got it..

Thanks everyone..

CurrentMonth:

=left(MonthName(Max(DDMonthYear)),3)

Previous Month:

=Date(addmonths(max(DDMonthYear), -1),'MMM')

[paulwalker]

Thanks for help Settu..

I hit Correct Answer............

[Anonymous]

Although it is resolved - I'd recommend to use date/time functions rather than string functions.  That is, the current month should be simple:

=date(Max(DDMonthYear),'MMM')

[paulwalker]

Yes Michael,

Your right....