Date Relationship with Fact table is Showing Many to Many

[Anonymous]

Hi Team,

Good day, I'm newbie to PBI. I'm facing the issue in table relationship. here is the issue details

I've created Date table in Dimension and Date field in Fact table with (12-03-2020 to 15-02-2021)  but when i tried to make a relation b/w both the tables it is showing as many to many.. my doubt is why not "one to many"

Thanks in advance.

Please help me out

[HotChilli · Accepted solution]

Any issues that are like this can be investigated using powerbi itself.

Create a table visual, pull Date from the Date Dimension on to the table twice.  Make the second one a COUNT (using the dropdown in the Values well).  That should show all the Dates and how many times they occur.  For a Date Dimension the count should be 1 all the way.

You can order the table visual by count to help investigate.

You can then look at where the Date Dimension has a problem