Forum Discussion
Data Validation when trying to create a date table
I'm trying to set a date table and I keep getting this validation error. I have other tables in this project that have date columns and when I try to create an actual date table, it won't let me.
I updated my PBI to the latest release and now my dashboard won't work, so I'm hoping to fix the issue by starting from scratch! I haven't even gotten to build the visuals (where I got the Error fetching data errors) to see if the visual will work.
Does anyone know what is causing the date table issue? In another post the issue was because it was the only table, but that's not the issue here. I have 2 other tables connected to it.
Also, is there any way to revert back to the older version of PBI?
DIM_Date =
VAR MinDate = DATE(2024, 1, 1)
VAR MaxDate = DATE(2024, 12, 31)
RETURN
ADDCOLUMNS(
CALENDAR(MinDate, MaxDate),
"Date", [Date],
"Year", YEAR([Date]),
"Month", FORMAT([Date], "mmmm"),
"MonthNo", MONTH([Date])
)Other Things
Remove the time component (12:00:00 AM) from your dates
Disconnect any relationships temporarily while setting up the date table
Clear existing date table markings in your model
Try refreshing the model after making these changes
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!Hi Anonymous
If you want to revert back to the older version of PBI, please refer to this link:
Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn
The document contains all the history version of the Power bi desktop and it's details of what's new in each of its releases.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
DIM_Date =
VAR MinDate = DATE(2024, 1, 1)
VAR MaxDate = DATE(2024, 12, 31)
RETURN
ADDCOLUMNS(
CALENDAR(MinDate, MaxDate),
"Date", [Date],
"Year", YEAR([Date]),
"Month", FORMAT([Date], "mmmm"),
"MonthNo", MONTH([Date])
)Other Things
Remove the time component (12:00:00 AM) from your dates
Disconnect any relationships temporarily while setting up the date table
Clear existing date table markings in your model
Try refreshing the model after making these changes
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!Hi Anonymous
If you want to revert back to the older version of PBI, please refer to this link:
Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn
The document contains all the history version of the Power bi desktop and it's details of what's new in each of its releases.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.