KPI

[#1]

stalwar1‌ I have one doubt regarding previous year formula in KPI. Im using this formula, which I thought it was quite good, but when I select year 2017, it will give me the actual year figure, but then it will give me zero in the previous year one. HELP PLEASE.

Thank you!!

Joaquin.

[sunny_talwar]

What is the expression?

[#3]

Sorry I forgot to include it...

Sum({$<[AÑO]={$(=max([AÑO]-1))}>}[Unidad Ventas])

Thanks.

[sunny_talwar]

Not sure if it makes any difference, but try this

Sum({$<[AÑO]={$(=Max([AÑO])-1)}>}[Unidad Ventas])

Moved the parenthesis from after 1 to before the minus sign.

Also, are you making selection in other date and time related field (other than ANO?

[#5]

Hi Sunny, I have tried that one too, and I dont think im making selection in other date and tme related field other than AÑO.

Thank you!!

[sunny_talwar]

Would you be able to share a sample to check it out?

[#7]

stalwar1‌

[sunny_talwar]

So this is without selections... can you show what happens when you select 2017 in ANO?

[#9]

Without selections is alright, as it shows the correct figures. They are incorrect when I start selecting.

[sunny_talwar]

I think the problem is that you are using a front end expression as your filter field.... why don't you use ANO as a filter instead of Year(FECHA)?