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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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