How to get the last value of the month

Q&A
,
2

Hi @ku1918

Create a calculated filed with rank and order date descending, grouped by Month/Year.

rank([{Date-field} DESC], [extract(‘YYYY’, {Date-field}), extract(‘MM’, {Date-field})])

Use Rank calculated field as filter and set filter condition equal to 1
image

Here is the results: Listing last day of the month and value

image

1 Like