Formula check

[JoseGarcia]

Hi there, 

trying to count measure values greater than 365.

Using formula: 

count({<Today()- EightD.D1_KPIDate= {">365"}>} [%ID_8D])

it is giving me error.

Any ideas?
Thanks as always!

[tresesco · Accepted solution]

Try like:

count(If(Today()- EightD.D1_KPIDate>365, [%ID_8D]))

Or,

count({<EightD.D1_KPIDate= {"=Today()- EightD.D1_KPIDate>365"}>} [%ID_8D])

[JoseGarcia]

that's great! Both work 🙂