Forum Discussion
MTD Measures Not Working
Hi Anonymous ,
from what you say I don't understan what you are using as a time reference. In order to have time intelligence functions to work you need to have a "calendar table" with all the dates in the time interval you are considering.
You can easily build it with calendar() function. https://docs.microsoft.com/en-us/dax/calendar-function-dax
Once you have it, you should connect the date in the calendar table to your inceptiondate and you should use the date in the calendar table as reference for time intelligence dax functions.
Hi Anonymous ,
from what you say I don't understan what you are using as a time reference. In order to have time intelligence functions to work you need to have a "calendar table" with all the dates in the time interval you are considering.
You can easily build it with calendar() function. https://docs.microsoft.com/en-us/dax/calendar-function-dax
Once you have it, you should connect the date in the calendar table to your inceptiondate and you should use the date in the calendar table as reference for time intelligence dax functions.
Thank you, elxinside! I am fairly new to Power Bi and did not realize I needed to have that calendar table for time intelligence functions. This not only fixed my MTD measures but I was also able to fix my 12 Month Rolling measures & YTD measures.