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.
I have a matrix with MTD calculation. In the grand total at the right hand side it always shows the latest months value rather than a sum of all columns?
Is it possible to show the Total as total of columns when using MTD calculation?
Calculation is = CALCULATE('Measures Table'[Sales Budget],DATESMTD('Date'[Date]))
Solved! Go to Solution.
@Danch89 , MTD usually show last month MTD in total
in this case, you can use [Sales Budget]
Or try a measure like
sumx(values('Date'[Month Year]) , CALCULATE('Measures Table'[Sales Budget],DATESMTD('Date'[Date])))
@Danch89 , MTD usually show last month MTD in total
in this case, you can use [Sales Budget]
Or try a measure like
sumx(values('Date'[Month Year]) , CALCULATE('Measures Table'[Sales Budget],DATESMTD('Date'[Date])))
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.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |