Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |