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
Suppose
dates Sales
2018 / 10 / 29 20
2018 / 11 / 30 20
2018 / 11 / 30 30
2018 / 11 / 30 40
2018 / 11 / 30 50
2018 / 12 / 30 60
2018 / 12/ 30 30
2018 / 12 / 30 20
2018 / 12 / 30 40
2018 / 12 / 31 60
2018 / 12/ 31 30
2018 / 12 / 31 20
2018 / 12 / 31 40
with the help of below measure we can easily get mtd but i need a number of row its get for calculating mtd like given below
MTD_SALE = CALCULATE(SUM('Table'[Sales]),DATESMTD('Table'[Date]))
need a solution like FTD 150 MTD 300
4 8
Replace SUM() with COUNTROWS()
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 |
|---|---|
| 51 | |
| 24 | |
| 13 | |
| 12 | |
| 11 |