The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
User | Count |
---|---|
56 | |
54 | |
54 | |
49 | |
30 |
User | Count |
---|---|
173 | |
89 | |
70 | |
46 | |
45 |