Unanswered

Using CountIF and date range

(1) Share

Report

Posted on by boom_powerapps

101

I have a simple gallery in PowerApps that counts the number of request status that equal the distinct list of those same statuses.

For example:

On Hold - 23

In Progress - 65

Request Completed - 170

This is the formula for the text field in my gallery that displays the value:

Items Property for Gallery:

Distinct(SVMRequests, 'Req Status')

Status Count Value Text Field:

CountIf(SVMRequests, 'Req Status' = lblreqstatus.Text)
 
I'd like help to update the formula so it counts only request statuses with a created date between 12 months ago and Today() instead of counting all of the rows in my dataverse table.
 
Thanks!!

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (0)

WarrenBelz 154,494 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @boom_powerapps

Probably something like this
Distinct( Filter( SVMRequests, CreatedOn > DateAdd(Today(), -365, Days) ), 'Req Status' )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee

Was this reply helpful? Yes No
WarrenBelz 154,494 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@boom_powerapps,

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No