Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Alediram
New Member

count if

I am new to Power BI and even in the use of DAX functions.
I have two tables linked one of purchase orders and another with dates (estimated, required and real).
I need to know how many orders I have per month-year, taking into account the estimated, required and actual date.
In Excel I use the formula = COUNTIF
Any suggestions would be much appreciated!
Thank you!

2 REPLIES 2
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @Alediram,

 

Could you be more precisely with your issue by posting your table structures with some sample/mock data, and the expected result? So that we can better assist on it. It's better to just share a sample pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploadingSmiley Happy

 

Regards

WolfBiber
Microsoft Employee
Microsoft Employee

Hey, 

please provide test data to help you.

Greetings. 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors