KPI sum the month ago

[Ari_vzla]

Hi team, 

    I am trying to create a KPI with the sum of value of the month ago

=sum({<Mes = {">=$(=MonthStart(AddMonths(Today(),-0)))<= $(=MonthEnd(AddMonths(Today(),-0)))"}>}[Picking mensual])

But, formula is sum month ago and one month more, this is, sum Aug and Sep. How can I fix it to get only the sum of Aug?

[Chanty4u]

use this 

script create yout 

  Date(MonthStart(Yourdatefield), 'M-YYYY') as Mes,

frontend:

Sum({<Mes = {"$(=Date(AddMonths(Max(MonthYear), -1), 'M-YYYY'))"}>}Picking mensual])

[Ari_vzla]

Sorry, I am still have an error, scrip show me error after as, but I dont know how fix it

=Date(MonthStart([Mes.autoCalendar.Date]), 'M-YYYY') as Mes

frontend:

=Sum({<Mes = {"$(=Date(AddMonths(Max(MonthYear), -1), 'M-YYYY'))"}>}[Picking mensual]])

Thank you 

Arieli 

[Chanty4u]

can you paste your date format please?

[Ari_vzla]

Sure, there yo go 

'DD.MM.YYYY';

Thank you 

Arieli 

[sunny_talwar · Accepted solution]

@Ari_vzla how about this since we are in Oct now and going back to Aug would need going back 2 months

=Sum({<Mes = {">=$(=Date(MonthStart(Today(), -2), 'DD.MM.YYYY'))<=$(=Date(Floor(MonthEnd(Today(), -2)), 'DD.MM.YYYY'))"}>} [Picking mensual])

[Ari_vzla]

Thank you so much, it works