Forum Discussion

alisonpappas's avatar
alisonpappas
Icon for Helper III rankHelper III
6 years ago
Solved

date table not working

My relationship between the date table and my data is not working. The date table is: marked as date table, and i have tried changing the data type to BOTH "date" and "date/time". the dates from my d...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    alisonpappas , The table where you are joining the date from the date table. Check if that date have timestamp.

    Let us say you are joining to start date of table1, check that the start date has timestamp or not. Best way to check is to change its data type to DateTime and choose a format that that has time and see do see any time other than 12:00 AM , if yes create a new date column

     

    New Date = [Start Date].date

    Or

    New date = date(year([Start Date]),month([Start Date]),day([Start Date]))

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi alisonpappas ,

First, you have to make sure that the data type of the reference fields in the two tables that create the relationship are the same. At the same time, the values of the two reference fields need to contain the same values, so that the data will display when the fields in the two tables be placed on the visual at the same time. Could you please provide some sample data of these two tables and the screenshot of Model tab?

You can review the following documentations about how to create and manage relationship.

Understanding relationships in Power BI Desktop

Model relationships in Power BI Desktop

Best Regards

Rena