Forum Discussion
Create Relationship
In the tabular database model, you can only create a relationship between two tables when at least one of the columns being used to create the relationship has unique values. It seems like both of your date fields have duplicates values.
You need to deteremine which of these two date columns in your two tables should have a unique values. Then use the Power BI Desktop query tool to de-duplify these duplicate date values so that the query outputs a table with unique column values. After that, you should be able to create the relationship.
In the tabular database model, you can only create a relationship between two tables when at least one of the columns being used to create the relationship has unique values. It seems like both of your date fields have duplicates values.
You need to deteremine which of these two date columns in your two tables should have a unique values. Then use the Power BI Desktop query tool to de-duplify these duplicate date values so that the query outputs a table with unique column values. After that, you should be able to create the relationship.
Thanks for the suggestion Ted. Question - how do you de-duplify these duplicate date values?
First, make sure that the column in question is based on Date and not DateTime when you examine it in the query edito window. Next, you use the Group By step so that every row withthe same date is collapsed into the single row.
Is this table you are working with a specialized Calendar table?
Thanks for suggestion. Do you or anyone know how to remove duplicate rows in Power Bi so the fields are unique?
