cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ramole
Level: Powered On

Count duedate

Hello Everyone,

 

I need help please i need to show how many due Date items outstanding, for example i need to count row only those due date please like screenshot

Thanks duedate.png 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Eelman
Level 10

Re: Count duedate

The basic idea would be to use CountRows() on a filtered data source. Say your Due date column is called DueDate and "Outstanding" means any date less or equal to today, then this structure could do what you want

 

CountRows ( Filter ( yourDataSource, DueDate <= Today()) )

View solution in original post

Eelman
Level 10

Re: Count duedate

Add this after Today():

&& ! ( Status = "Closed" )

If Status is a Choice column you'll need to use

Status.Value = "Closed"

View solution in original post

7 REPLIES 7
Eelman
Level 10

Re: Count duedate

The basic idea would be to use CountRows() on a filtered data source. Say your Due date column is called DueDate and "Outstanding" means any date less or equal to today, then this structure could do what you want

 

CountRows ( Filter ( yourDataSource, DueDate <= Today()) )

View solution in original post

Ramole
Level: Powered On

Re: Count duedate

Hi @Eelman

Thanks thats counting good, but i would to minus status = closed example CountRows ( Filter ( 'Shipments ', DueDate <= Today()) ) minus STATUS "CLOSED" so it does not count when i select status closed please thanks. 

Eelman
Level 10

Re: Count duedate

Add this after Today():

&& ! ( Status = "Closed" )

If Status is a Choice column you'll need to use

Status.Value = "Closed"

View solution in original post

Ramole
Level: Powered On

Re: Count duedate

Hi @Eelman  

Thank you so much it sorted now 

 

Thanks again. 

Ramole
Level: Powered On

Re: Count duedate

Hi @Eelman 

is there a way to use it on sum, example i have a sum field called  Shipping Fee  so i need first to count as a choice field called Shipping Method and choices are FedEx DHL UPS  so something like before first to count how many amount is for FedEx to show as a sum amount  

EXAMPLE 

FedEx $300

DHL  $120  and so on 

 

Thanks 

 

Eelman
Level 10

Re: Count duedate

Yes, it can be done like this:

ClearCollect ( colShippingCost, AddColumns( Distinct('Shipment', 'Shipping Method'), "ShipCosts", Sum( 'Shipment', 'Shipping Method' = Result)) )

Once in a collection you can then access it how you want ie gallery, labels, etc

Note: the above code is from memory and untested so it may not be 100% correct. Maybe start a new post if that happens so others could chime in and also those with similar queries can also learn
Ramole
Level: Powered On

Re: Count duedate

Hi @Eelman 

 

i figured already out that thanks but my question now is how can i sum 2 weeks.

Helpful resources

Announcements
thirdimage

Power Platform 24

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (5,505)