Summarize table with start-date and end-date filter

[Marty_H]

Hi everyone,

I would like to find out why my date filter isn't working.
In the picture below you can see I'm making a summarized table and would like to filter out all the rows of data for which the StartTime (date) is outside of the 2 dates I defined as DateStart and DateEnd.



Should I do it differently?

Thanks in advance,

Marty H.

[Marty_H · Accepted solution]

I found the solution:

SixMonthSummary = 
SUMMARIZE(FILTER('Trending_Data','Trending_Data'[StartTime]>= EDATE(TODAY(),-6)),Trending_Data[Mechanical Name],Trending_Data[Location],Trending_Data[Text],Trending_Data[FlowNumber],Trending_Data[ImpactOnTA],"Count",COUNTROWS(Trending_Data),"Summed duration",((SUM(Trending_Data[Duration])/1000)-1)/60,"Impactfactor",SUM(Trending_Data[Impactfactor]))