filter Last 30 days data.

[Anonymous]

Hi All,

How to filter Last 30 days data.

My expression: It is not working.

Sum({<Affected_Date={'>=$(=max(Affected_Date)-30)<=$(=max(Affected_Date))'}>}[Overall Availability%])

Pls help me.

Thanks,

Krishna

[OmarBenSalem]

Try as follow:

Sum({< Affected_Date={">=$(=addmonths(max(Affected_Date),-1)) <= $(=max(Affected_Date))"}>}[Overall Availability%])

result:

[adj29block]

Hi Krishna,

Look at the attached PDF

J-B

[luismadriz]

Hi Krishna,

your expression was almost perfect, the only thing you needed to do was to transform max(...)-30 to a date

Sum({<Affected_Date={'>=$(=date(max(Affected_Date)-30))<=$(=max(Affected_Date))'}>}[Overall Availability%])

I like Omar's proposal better because it subtracts a whole month but of course, it all depends on your requirements,

I hope this helps,

Regards,

Luis

[luismadriz]

Hi Krishna,

Please remember to close the thread by marking the correct and helpful replies,

Many thanks,

Luis