Expression calculation for (only) last month from selected months?

[#1]

Hi,

I have a table with an expression that calculated Average Survey Answers over a selected period of time (months). I have to add another expression to do the same calculation - Average Survey Answers, but for the last month from the selected months. So for example if I select Apr, May, Jun and July I want my second expression to display the results for July only, as July is the last month is my selection. My expression is based on a variable called. Any ideas? I cannot post the dashboard as it's client work...

[Anonymous · Accepted solution]

Katarzyna,

See a generic idea in the attached.  I'm using set analysis comparing Month with the max(Month).

Regards,

Michael

[#3]

Thank you Michael, that worked!