How can I filter a KPI using a date?

[Skylia]

Hello everyone!

I need your help 🙂 I have to make a KPI with these rules:

(1) I have to count a number of records when the column is "Yes" for the last 12 months of a date field ( date + 30 calendar days). Note: I must add 30 calendar days to this date field.

(2) I have to count only the records that have breached the field [date + 30 calendar days], this is compared with Today(). So I would get the unfulfilled

(3) Obtain the final calculation: (1 / 2) %

I stayed here

Count({<[COL1]={"Y"}>}[N_Register]

Year([DatePas]+30)-1 

EXTRA: How can I add calendar days to a date?

[Skylia]

I do it!

num(Count({<[AÑOMAXIMO]={">=$(vMinAñoFechaMaxA)<=$(vMaxAñoFechaMaxAtencionA)"},[Presentacion recurso de reconsideracion]={"SI"},[FechaMaxima]={"<05/05/2021"}>}[N_REGISTRO_MODULO])
/Count({<[AÑOMAXIMO]={">=$(vMinAñoFechaMaxA)<=$(vMaxAñoFechaMaxAtencionA)"},[Presentacion recurso de reconsideracion]={"SI"}>}[N_REGISTRO_MODULO]),'#,##0%')