Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Ambiguity between data table tables (date)

Hi every one,

 

There are 3 tables with each one a date column (dd/mm/yyyy)

I created 1 another table X with calendar = ("01/01/2018";31/12/2020") 

Then I link these 3 tables to the table X with the date column

So I have 2 corrects and 1 wrong links (1..*)  and it say I CAN NOT CREATE THE 3rd RELATION because it could create ambiguity between the table X and 2 others tables .

 

Could you explain me why and how can resolve it please ? 

 

Thank you guys !

Need Help
Tips and Tricks
  • HotChilli's avatar
    HotChilli
    6 years ago

    Going from calendar-> Counter Flaws

    One path is along the relationship connecting both tables. Calendar-> Counter Flaws

    The second path would be from Calendar->vWebSitesEform-> vWebSites->Counter Flaws

     

    Powerbi wouldn't let the relationship be created from Calendar->vWebSitesEform because it can't allow 2 paths from calendar-> Counter Flaws.  Because it doesn't know which way to go (path 1 or path 2).

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    There should not be two-path to reach from the date table to another table.

    Let Date -> A,

    A-B.

    Date -> B

     

    It means the Date to B has two paths.

     

    Also if needed you can convert date to mm/dd/yyyy

    mid(DD__MM__YY[Date],4,2) &"/"& left(DD__MM__YY[Date],2) & "/" & right(DD__MM__YY[Date],4)
     
    Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
    Thanks. My Recent Blog -
    Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
    Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

    Connect on Linkedin

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I'm sorry but I don't understand at all what did you say 

       

  • HotChilli's avatar
    HotChilli
    Community Champion
    6 years ago

    If the tables are unrelated and columns from one table don't have a dependency on another then you won't get that message.

    So I suspect there is another path (via relationships) that connect the third table to table 1 or table 2.

    Can you show us a picture of the relationships?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

       

      You're right about it 

       I changed the relation between vWebsitesEform and vWebsites by (*..1) and the direction of filter from vWebsite to vWebSitesEform . The result is i can active now the link between Calendar and vWebSitesEform.

      But I don't understand the reason. Could you explain me please ?

       

       

      • HotChilli's avatar
        HotChilli
        Community Champion
        6 years ago

        Going from calendar-> Counter Flaws

        One path is along the relationship connecting both tables. Calendar-> Counter Flaws

        The second path would be from Calendar->vWebSitesEform-> vWebSites->Counter Flaws

         

        Powerbi wouldn't let the relationship be created from Calendar->vWebSitesEform because it can't allow 2 paths from calendar-> Counter Flaws.  Because it doesn't know which way to go (path 1 or path 2).