Forum Discussion
Calenderauto dates blank when Table Date has a corresponding date value
Please help me figure out why would some of my calenderauto dates be blank if my Table Date has a corresponding date value. My Table Date column is a date data type. This a oracle datasource. What are some things I can do to troubleshoot?
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.
1 Reply
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.