Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Gowtham174
Creator

Max Month end Date

Hi all,

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

  

REPORT_DATEMonth
01/07/2018Jul

02/07/2018

-

Jul

-

24/07/2018Jul
25/07/2018Jul
26/07/2018Jul

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

I need 26th Jul

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

Thanks,

Gowtham

1 Solution

Accepted Solutions
andrey_krylov
Specialist

Hi, maybe without MonthEnd()

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

View solution in original post

5 Replies
andrey_krylov
Specialist

Hi, maybe without MonthEnd()

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

rakeshkumar1890
Creator

use this

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

Gowtham174
Creator
Author

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
Creator III

Hi,

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

Regards

Chris

justinphamvn
Creator II

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.