Forum Discussion
MTD calculation does not work
I was trying to calculate data filtered by date. With past data it worked very well, but for MTD or when I'm trying to use the current month data, it just does not work as usual. The column retur...
MTD Sales = CALCULATE([Total net sales], DATESBETWEEN(DateTable[Date].[Date], DATE(2019,09,01), today()))
Maybe since the end date has not happened yet it is having trouble with that. I'd try it with "today()" as the end date.