Forum Discussion
Why does my DAX Datetable not include dates for 2020?
Hi ansa_naz
check if in your data exists data from 2020 because in CALENDARAUTO() function range of dates is calculated automatically based on data in the model.
You can also use CALENDAR() function instead https://docs.microsoft.com/en-us/dax/calendar-function-dax
do not hesitate to give a kudo to useful posts and mark solutions as solution
Hi ansa_naz
check if in your data exists data from 2020 because in CALENDARAUTO() function range of dates is calculated automatically based on data in the model.
You can also use CALENDAR() function instead https://docs.microsoft.com/en-us/dax/calendar-function-dax
do not hesitate to give a kudo to useful posts and mark solutions as solution
Thanks for that, didnt realise the CALENDARAUTO function uses dates in the data model. Used CALENDAR and it works perfectly, cheers