Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
Solved! Go to Solution.
Hi @sa34techer - 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.
Proud to be a Super User! | |
Hi @sa34techer - 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.
Proud to be a Super User! | |
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 61 | |
| 49 | |
| 41 | |
| 40 | |
| 22 |
| User | Count |
|---|---|
| 171 | |
| 136 | |
| 119 | |
| 80 | |
| 54 |