[BUG/GLITCH?] Relationships from Calendar Table glitches out Date Fields in Fact Table

[lee_a]

Hi, 

I'm experiencing a weird issue that I need help with. 

In my Fact Table, I have two fields which are both formatted as "Date" type and format: "Doc Date" and "Payment Clearing Date" 

  

The issue I'm having is that whenever I create a relationship from the "Date" field in my Calendar Table to either "Doc Date" or "Payment Clearing Date" fields in my Fact Table, that date field is no longer recognized fully as a "Date Type" field. 

As shown in the picture above, currently I've linked the "Date" Field in my Calendar Table to "Doc Date" and note in the picture below, the Calendar Icon no longer displays, however it continues to display for the "Payment Clearing Date" field.

If I switch the relationship to connect to "Payment Clearing Date" the issue will then be on that field, and "Doc Date" returns to normal but then "Payment Clearing Date" has the issue. 

This issue causes PowerBI to no longer detect the connected field as a "Date Type" field in when used in certain measures I have. The field only behaves as expected when not connected to my Calendar Table. When no relationship exists between these tables both date fields return to normal. 

Not sure if the issue exists with connection to any Date value or just this Date value in this Calendar Table. I don't have any other ways to test this. 

All three fields fields have the following Date Type under the modeling tab. 

This is the relationship setting

This is what all Date fields in my Fact table look like in the Transform tab of Query Editor:

Has anybody had this issue before?

Thanks

AL

[lee_a · Accepted solution]

Hi, I found the solution in this post here. 

https://community.powerbi.com/t5/Desktop/Date-Relationship/td-p/321105

I think think the need for this work around is kind of inefficient. Maybe this can get streamlined in a future update. 

[gooranga1]

They are still date fields but I think that symbol is to do with the automatic Time Intelligence settings that are switched on. If you go to File -> Options and Settings -> Options -> Data Load there is a setting called Time Intelligence. Switch it off as if you already have a date lookup you don't need it and it just makes your pbix files bloated. I have just switched it off from one of our pbix files and it reduced the size from 130Mb to under 100Mb.