cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I

## Count with filters after a date

I have been trying different ways to get the data I need with no success so hoping someone out here can help me. I'm trying to create a few measures that I can put into a graph. In summary I need to count the number of Projects for each color , step that are after 4/1/2022.  Below is an example table and the exected results table below it.

 Proj # Step Status Color Date 363040 Close Yellow 3/18/22 373914 ETJ Red 4/29/22 376363 ETJ Red 5/27/22 373913 ETJ Yellow 2/5/22 379054 ETJ Yellow 6/10/22 378473 Close Red 8/7/22 340188 Close Yellow 8/14/22 339964 Close Yellow 6/9/22 352304 ETJ Red 4/30/22 353587 Close Red 7/31/22

Expected Results: Row 1 & 4 would not be part of the calculation since they are before 4/1/2022

 Color Step Count Red ETJ 3 Red Close 2 Yellow ETJ 1 Yellow Close 2

Thank you,

dk6569

1 ACCEPTED SOLUTION
Super User

``````Count =
CALCULATE (
COUNTROWS ( Table ),
Table[Date] >= DATE ( 2022,4,1 )
)``````

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Super User

``````Count =
CALCULATE (
COUNTROWS ( Table ),
Table[Date] >= DATE ( 2022,4,1 )
)``````

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors