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])))
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
119 | |
75 | |
66 | |
51 | |
49 |
User | Count |
---|---|
183 | |
101 | |
80 | |
79 | |
77 |