Forum Discussion

JoseDavid's avatar
JoseDavid
Icon for Helper I rankHelper I
8 years ago
Solved

Help to Join diferents dates tables

Hello everybody   I need to calculate the difference between the sales and the forecast.   The problem it´s each table has his own dates, like that:   and When I make a formula or ...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi JoseDavid,

    As the error message said, the many to many relationship is unsupported in Power BI, one of the columns must have unique values. You should remove the dulplicate values and create relationship between two tables.

    Thanks,
    Angelia

JoseDavid's avatar
JoseDavid
Icon for Helper I rankHelper I
8 years ago

 

Hello Thejeswar

 

I have created the date table with the same format of each other.

 

But when i try to combinate the tables, it´s give me the following error:

 

 

 

"You can not create a relationship between these two columns because one of the columns must have unique values".

 

Then, I have tried combinate from the querys editor but i don´t find a formula wich combinate dates 1 and dates 2........ :-(

 

 

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi JoseDavid,

As the error message said, the many to many relationship is unsupported in Power BI, one of the columns must have unique values. You should remove the dulplicate values and create relationship between two tables.

Thanks,
Angelia

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi JoseDavid,

      I am glad to help you, please mark the reply as answer if it is useful.

      Thanks,
      Angelia