cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jayceeb
Helper III
Helper III

Sum the selected items with filtered date in a chart

 

Hi, I have chart with filtered date now I want to get the sum of this same items regardless of the date filtered.

Any help?

My code is:

SortByColumns(Filter(Search(AddColumns(
GroupBy( Breakages,"DESCRIPTION","Date_x0020_Filter","GroupData"),
"totalQuantity",
Sum(GroupData,'Total Count')),TextSearchBox.Text,"DESCRIPTION"),
DateValue(Date_x0020_Filter) <= DatePicker2.SelectedDate,
DateValue(Date_x0020_Filter) >= DatePicker1.SelectedDate),"totalQuantity",Descending)

 

jayceeb_1-1664810596819.png

 

0 REPLIES 0

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,612)