
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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_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
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, maybe without MonthEnd()
Date(Max(REPORT_DATE),'YYYY-MM-DD')


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
use this
Date(Max(REPORT_DATE),'YYYY-MM-DD')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
as soon as you select a month, you should see the max date of the selected month.
Regards
Chris

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
