return the last month

[wanyunyang]

I have a year filter, if I select 2017, it returns 12 (last month in 2017). If select 2018, it return 5 (current month).

Is that possible?

[Digvijay_Singh]

I think Max(Month) will respond as per your selection and needs

[rafatashiro]

I think U can try count( distinct Month) too