Display KPI of latest month

[Riaandk85]

I am a rookie and are struggling with a few things.

I've got daily data with auto aggregated date fields:  YearMonth ,MonthAgo, YearsAgo etc.

Im trying to inlclude a KPI to display the average value of the last month which will be 2022-Jun

I've got the following expression: =Sum({<[_id.autoCalendar.YearMonth]={"$(=Max(_id.autoCalendar.YearMonth))"}>}[site_area_per_visit]) , but it keeps giving a 0 value.

Please assist

[Riaandk85]

Correction, the expression is as follow as I need to display the average, but then the value is given as "-"

=Avg({<[_id.autoCalendar.YearMonth]={"$(=Max(_id.autoCalendar.YearMonth))"}>}[site_area_per_visit])