Forum Discussion
lcasey
Post Prodigy
9 years agoDates are Broken Once again!
I dont understand why Dates keep breaking in Power BI. There must be a serious flaw in the Power BI rengine somewhere. I created a very simple date table: Calendar = CALENDAR(Min(Helpdesk[date...
lcasey
Post Prodigy
9 years agoOk this is weird,
After I went into Edit Query Mode and performed a tranform on the fields it worked. I thought that Power BI Desktop , making changes in the tables in Desktop was the same as performing field changes in the back-end query editor.
I had set the fields in Power BI desktop as Date fields.
Looks like I need to start making ALL changes in Query Editor as it actually performs transformation differently then the desktop application.
Baskar
Resident Rockstar
9 years agocool ,
Can u please check the data type for Date column in both Table.
Because it is working for me without any trouble.