Date table - Relationship NOT Working

[Anonymous]

Hi all,

I am trying to create a relation to a Date Table and use Time intelligence functions, but it looks like there is some issue with the relationship.

I have looked into many similiar issues, but didn't found a solution. I have the feeling it is something with the dates in my Fact table. Please help me as I have s

Here is the Date Table, Master Date formatted as Date:

Here is the Fact Table, with the Date column "Time level 2" formatted the same way:

Here is the 1toMany relationship:

Here is what happens when I try to create as simple matrix:

[amitchandak · Accepted solution]

One of the following

1. date calendar does not have all the dates

2. The transaction table date has time but shown in the date format. So change the format and to date with time and check. It  has time to create a new date column date = table[datetime].date

[Anonymous]

Hi, 

I am facing similar issues.  I have created a separte date table using calendar auto function and marked the date column in the date table as the date table.  The fact table has multiple date columns with time stamp.  I have changed the date columns in the fact table to date only format and connected it with the date table.  Even then the relationship didnt work.  I also tried modifying the date column in the date table to date/time even then i am facing the similar issues of getting the matrix as mentioned in the post above.  Can you please suggest what you meant when you referred to new date column date = table[datetime].date.  I also checked whether all the dates are there in the date table.  Even the dates are there since its created using calendar auto function.

Any other suggestion would help.

Thanks & Regards,

Padmaja 

Thanks 

[Anonymous]

Thanks. I have looked in the calendar, but at the end it was missing values for 2020. How I didn't see that...