Forum Discussion

lcasey's avatar
lcasey
Icon for Post Prodigy rankPost Prodigy
9 years ago

Dates 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...
Need Help
Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
9 years ago

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 ?

 

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
    Baskar
    Icon for Resident Rockstar rankResident Rockstar
    9 years ago

    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 . 

     

     

     

     

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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.