Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try as follow:
Sum({< Affected_Date={">=$(=addmonths(max(Affected_Date),-1)) <= $(=max(Affected_Date))"}>}[Overall Availability%])
result:
Hi Krishna,
Look at the attached PDF
J-B
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
Hi Krishna,
Please remember to close the thread by marking the correct and helpful replies,
Many thanks,
Luis