How to get Count of Incidents for last 90 days

[drrai66]

Hello Experts,

I have 2 years of Incident data, so Unfortunately I am not able to attach any data or Picture this time, it is too big. The data has column such as Incident number, INcident Type( Auto or User). I can individually calculate the Number of Total  auto Incidents and Total User Incidents  for 2 years. I just need now last 90 days count of Auto and user Incidents. I can't do any filtering in Query Editor, as Initially this data set was for 4 Years and I reduced it to 2 years to do my other calculations. Any Formula or way?

Thanks

Deepak

[MFelix · Accepted solution]

Hi @drrai66,

Without any data is difficult to give you the rigth answer to your question however you should have something like this:

 Last 90 days = 
var Select_Date = MAX(Table[Date])

Return

CALCULATE( COUNT(Table[Incident]);Table[Date] >= Select_Date - 90)

This should work however did not test it out in PBI not on computer right now if you can provide a sample of your data just a simple data mockup would be helpfull.

Be aware that for this to work you need to have a date filter on your visuals, however if you want to have it for current date just change it to:

 Last 90 days = 
CALCULATE( COUNT(Table[Incident]);Table[Date] >= TODAY() - 90)

Regards,

MFelix

[drrai66]

Hi

Sorry for Delay, I applied it and it Worked Perfectly!!!

Thanks

Deepak