Forum Discussion

650AA's avatar
650AA
Icon for Helper I rankHelper I
2 years ago

Date Table relationship Issues

Hi all looking some advice and guidance, I have set up a date table , marked it as a date table, and created an active relationship with my facts table however when I am using the date from the date ...
Need Help
gmsamborn's avatar
gmsamborn
Icon for Super User rankSuper User
2 years ago

Hi  650AA 

 

It looks like a problem with the relationship since the column has a blank date.

 

Both of the date columns in the realtionship should be date, not datetime.  If your fact table date column is datetime, you'll have to duplicate that column (in Power Query) and change the datatype of the new column to date for use in the relationship.