Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
When I check the field properties they are correct.
When I try to use the Entry Date from my data table in a calculation, it gives me an error.
How do I fix this relationship problem?
Try to mark your calendar as date table
The calendar table is a calculated table:
@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.
Sharing a dummy PBIX file to represent your scenario would help me further investigate your issue.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@kg4u
Check how you have defined the date range for your calendar table. It should always contain full years. 1st January to 31 December.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |