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.

az38's avatar
az38
Community Champion
6 years ago

leandroparischi 

maybe it would be better to create some surrogate date key in both of tables with the same format with Power Query?

like "YYYYMMDD" formatted as text 

Text.Combine({Text.From(Date.Year([Date])), Text.From(Date.Month([Date])), Text.From(Date.Day([Date]))})