max(Month Name) not working

[mahitham]

Hi Experts,

Can any one please help me on below issue.

I have a [Month Name] field in MMM YYYY format.

I have to show Max([Month Name]) in kpi instead of Apr 2018 getting 43.19k.

In the backend I have calculated [Month Name] from file name like below.

Pease help me to show Apr 2018

Thanks in advance.

[ruanhaese · Accepted solution]

Try

Date( Max([Month Name]), 'MMM YYYY')

The date function formats the numeric value.

[jyothish8807]

Else try this also:

Date(Max(Date#([Month Name], 'MMM YYYY')),'MMM YYYY')

Also set your number format as Date

Br,

KC