Forum Discussion

Marty_H's avatar
Marty_H
Frequent Visitor
4 years ago
Solved

Summarize table with start-date and end-date filter

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.

Need Help
  • Marty_H's avatar
    Marty_H
    4 years ago

    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]))

     

1 Reply

  • Marty_H's avatar
    Marty_H
    Frequent Visitor
    4 years ago

    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]))