Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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()
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.