Forum Discussion
Post ProdigyDates are Broken Once again!
lcasey Yeah, I've had this same scenerio, the first time it took me a long time to figure out why things weren't working. Despite the date table being a product of the "model" and not imported information, I still had to do what you describe and make sure I went into edit queries to ensure the data type was changed to date.
Post ProdigyThanks for confirming this. Now that I know I must use the edit query window to make any type of changes , even calculated columns and Measures, I think I will have much less issues building reports.
Hopefully this helps someone having issues like this. Even when I created a Number column in Power BI desktop for sorting it doesnt work. Everything Must be performed in the edit query window to work.
- Baskar
Resident Rockstar
In Development canvas itself we can change data type, no need to go query editor window.
The same senario is working for me , then y can't u ?
Baskar I doubt it is the same scenerio. The issue is frustrating because the data type appears correct in the development canvas, but when you create relationships (based on a DAX calender table) the relationships don't work. The assumption was that one would think that if I created a "Date" table in DAX which is in the "development canvas / model" then I wouldn't have to go into query editor to set the datatype, but in this case you do.
- Baskar
Dear Anonymous
Here i was create on calender master using "Calender " DAX Function.
and One is from Data Source.
I have created relationship between these two tables using Date Key. It is woking me perfectly .
Correct me if am wrong .
