Forum Discussion
Post ProdigyDates are Broken Once again!
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.
Resident RockstarIn 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 .
Baskar I'll update this thread when i come across it again. I don't recall specifically what the scenario is with the datasets. I don't come across it all the time, which is why the first time around it took me a while to resolve. (because I didn't expect it). I was merely confirming that I have run into this same scenario on multiple occasions, and everytime it dealt with the date table built in DAX not working with another column.