Forum Discussion
Date column from dataset not working with Date Table
I've got a Date Table I'm creating relationships from my dataset to and everything has been working fine until I tried adding this new table. Table QryRptWorkOrder has a DateFinished column that I have created a many to one relationship with my Date Table column "Date" that is formated as a date table. I've also added "Year" Columns to both tables that calculate the year of the date.
When I use a slicer to filter using my Date Table's Year column, I get incorrect information including a blank category which there is no blank data for. When I use the same slicer using my QryRptWorkOrder's Year column, the correct info is returned. See pictures.
My question is why is this happening? Both date columns are set as the same Data type and format. Why would it be returning blank fields when it's connected my Date Table?
Few reasons
1. The date in fact has time and not visible because of format, create a date column
Date = Table[Datetime].date
2. Total date in Date table is less than what is required by the fact
3. The join is disabled or direction is wrong
Appreciate your Kudos.
2 Replies
- amitchandak
Super User
Few reasons
1. The date in fact has time and not visible because of format, create a date column
Date = Table[Datetime].date
2. Total date in Date table is less than what is required by the fact
3. The join is disabled or direction is wrong
Appreciate your Kudos.
That was the problem, thank you!
