Forum Discussion

giroldoale's avatar
giroldoale
Icon for Helper I rankHelper I
5 years ago
Solved

Connecting two tables with dates

Hi, I have some doubts with relationship through dates. My aim is to have a single table called "Calendar" where I connect all the DataTable with dates, so use only the date into "Calendar" to work...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi giroldoale ,

     

    For the second question, to my knowledge, the relationship is always from 1 to many.  In the case of 1: 1, it could not identify which is "many".Therefore, 1:1 can only be a one-way direction.

    For the third question,it is intended behaviour, in this case you will use date field from date table to work in your visuals.Refer to :Solved: Re: Date hierarchy missing - Microsoft Power BI Community

     

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