Hi, I am creating a KPI object. I want to display last month data when no selections are made. For this reason I added new variable "LastMonth" = max(YearMonth). In KPI object I set expression for measure avg({<[Date]={'$(vMaxYearMonth)'}>}[KPIname]). It gives me still average of all months instead of just one last month value. Can someone help with this?
