Forum Discussion
Date table - Relationship NOT Working
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 iss...
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
amitchandak
Super User
Super UserOne 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
Thanks. I have looked in the calendar, but at the end it was missing values for 2020. How I didn't see that...