Forum Discussion
Solved
MTD values gives incorrect Grand Total
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...
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])))
amitchandak
Super User
Super UserDanch89 , 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])))