Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
kg4u
Helper I
Helper I

Date isn't recognized after connecting calendar table

When I connect my calendar table to my data table, the date on the data table is no longer a date. The calendar icon is no longer present on the data table. 

 

kg4u_0-1705692590190.png

When I check the field properties they are correct.

kg4u_1-1705693043970.png

When I try to use the Entry Date from my data table in a calculation, it gives me an error.

 

kg4u_2-1705693224146.png

How do I fix this relationship problem?

 

 

4 REPLIES 4
Bibiano_Geraldo
Resolver I
Resolver I

Try to mark your calendar as date table

Bibiano_Geraldo_0-1705741169977.png

kg4u
Helper I
Helper I

The calendar table is a calculated table:  

Calendar = CALENDAR(DATE(2020,01,01),DATE(2025,12,31))

@kg4u 

Not sure if your Entry Date column in your data table has time portion and it causes this issue, try to remove time portion by going to Power Query and try. 

Fowmy_0-1705730090244.png


Sharing a dummy PBIX file to represent your scenario would help me further investigate your issue.


 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Fowmy
Super User
Super User

@kg4u 

Check how you have defined the date range for your calendar table. It should always contain full years. 1st January to 31 December. 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.