Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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!
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 uploading. ![]()
Regards
Hey,
please provide test data to help you.
Greetings.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 97 | |
| 73 | |
| 50 | |
| 46 | |
| 44 |