Ambiguity between data table tables (date)

[Anonymous]

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 !

[HotChilli]

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]

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 · Accepted solution]

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).

[Anonymous]

I understand now. Thank you so much !

[amitchandak]

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]

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