Basically, I want a KPI with a measure, lets say Sales for example. I want to show the max date's month sales and I want the second measure to have the growth in comparison to the previous month.
1 Measure:
sum({$<Year_Date={'$(=year(vMaxData))'}, Month_Date={'$(=month(vMaxData))'}>} Sales) -Working Fine
PS: vMaxData= Max(Date)
I want to use a month filter and I want the KPI to show the results according to the filter.
