Max Month end Date

[Gowtham174]

Hi all,

Can you please help me to get the Max Month end date for the below set of data.

REPORT_DATE	Month
01/07/2018	Jul
02/07/2018 -	Jul -
24/07/2018	Jul
25/07/2018	Jul
26/07/2018	Jul

I tried with below expression its giving me 31st Jul.

I need 26th Jul

Date(MonthEnd(Max(REPORT_DATE)),'YYYY-MM-DD')

Thanks,

Gowtham

[andrey_krylov · Accepted solution]

Hi, maybe without MonthEnd()

Date(Max(REPORT_DATE),'YYYY-MM-DD')

[rakeshkumar1890]

use this

Date(Max(REPORT_DATE),'YYYY-MM-DD')

[Gowtham174]

I need to show month end if other month is filter

for example: if i select month Jun i need to see 30th Jun.

Not Max date so above expression will give me max date for all the month

[igdrazil]

Hi,

as soon as you select a month, you should see the max date of the selected month.

Regards

Chris

[justinphamvn]

Hi,

Try it

***Using Chart, Table:

Date(Aggr(Max(REPORT_DATE),Month),'YYYY-MM-DD')

***Using KPI:

Date(Max(REPORT_DATE),'YYYY-MM-DD')

Hope this help,

Justin.