Forum Discussion
Calenderauto dates blank when Table Date has a corresponding date value
Hi Anonymous - Check if your Table Date column contains:Dates outside the valid Power BI date range (1/1/1900 to 12/31/9999).Null values or blanks in the source data.
you can , use CALENDAR instead of CALENDARAUTO to explicitly specify the date range
CalendarDebug = CALENDAR(MIN('YourTable'[Table Date]), MAX('YourTable'[Table Date]))
and also you have check on model view ,select the Table Date column, and confirm the Data Type is Date (not DateTime or Text).
The above approaches helps you to find the issues. please check.
Hi Anonymous - Check if your Table Date column contains:Dates outside the valid Power BI date range (1/1/1900 to 12/31/9999).Null values or blanks in the source data.
you can , use CALENDAR instead of CALENDARAUTO to explicitly specify the date range
CalendarDebug = CALENDAR(MIN('YourTable'[Table Date]), MAX('YourTable'[Table Date]))
and also you have check on model view ,select the Table Date column, and confirm the Data Type is Date (not DateTime or Text).
The above approaches helps you to find the issues. please check.