Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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]))
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]))
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |