Forum Discussion

leandroparischi's avatar
leandroparischi
Frequent Visitor
6 years ago
Solved

Relationship between dates

Hi, some time ago I made a CALENDARAUTO() table for date reference. I use in every project i work (dCalendario) But when I need to create a relationship between dCalendario.Date and table1.DueDate...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi leandroparischi ,

     

    Like this?

    After creating relationship

    This is normal. After the relationship is created using the date column, only the date column of one of the tables can use the hierarchy. You can do more tests yourself.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

leandroparischi - That's really odd. Have you tried setting your columns in both tables back to Date or Date/Time. 

leandroparischi's avatar
leandroparischi
Frequent Visitor
6 years ago

Greg_Deckler I tried do this in my DueDate field.

In Power Query, the Due Date field is categorized as a Date type. Shows the date icon and etc.

In the Column Tools tab, it shows the type as Date as well.

But it is not working as a date field and I believe that is the reason for my dCalendario table can't use DueDate field as reference.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    leandroparischi - I was thinking to try it in the "Column Tools" section of the ribbon when in Report view.