How to create KPI chart with Month condition

[QS21]

Hi All,

I am facing a challenge with the KPI chart, Text and image and multi KPi chart. basically I tried all KPi charts.

I am trying to create a dynamic commentary im my report using text and image chart where we can write text and also add measure next to it. while doing so I am trying to write comments comparing current month to last month like below:

The BOLD ones below are measures.

"Max(sale) current month is 100, Min Sales Current month is 50 where variance between max and min sales DECREASED compared to last month "

If I do not apply any month condition in the measure it show overall value. If I apply month condition, it does not display any value. and the "INCREASED, DECREASED" part is not at all working as it has condition that involves current month and last month. Someone please help. 

Logic is working fine when I put it in a table or any other chart.

IF(
IF(Monthname(MTH)=MonthName(today(),-2),(max(total <NAME> aggr( Avg(Sales),NAME,MTH))
- min(total <NAME> aggr( Avg(SALES),NAME,MTH))))
>
IF(Monthname(MTH)=MonthName(today(),-3),(max(total <NAME> aggr( Avg(SALES),NAME,MTH))
- min(total <NAME> aggr( Avg(SALES),NAME,MTH))))
,'INCREASED','DECREASED')

Please help!

[dmac1971]

Hi, I think I understand what you are trying to achieve here.  Why not use Max(Month) vs Max(Month)-1 here instead though, this way you can isolate months in filters etc and the calculation will still work.  I would also ask are you using a master calendar, if not you should.