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.
There is a 1-* relationship that exists between my Date/Calendar table and the Projects table, which contains the ProjectStartDate. When I add the ProjectStartDate field into a table with the Date field, gaps show up in the Date field, even though dates exist in that field for the ProjectStartDate. If anything, I would expect gaps in the ProjectStartDate field and, of course, dates should be listed in both columns when there are matches in both fields. Any ideas on why this is happening?
Solved! Go to Solution.
Aha! I think I see your issue. Your dates have start and stop times in them. But, when you create a calendar table, you will get everything as 12:00:00 AM. So, if the times don't match up, no relationship. I'm guessing this is the issue. So, you would want to create a column in each table that is only the date or you would create a column in your Project table that is the date with a time of 12:00:00 AM and use that as the relationship to your Calendar table.
Are you sure you have 2019 dates in your Calendar table?
Any way to share your data or your file? Difficult to recreate.
@Greg_Deckler Here's a dropbox link to the file. Let me know if you have any problems accessing it.
Aha! I think I see your issue. Your dates have start and stop times in them. But, when you create a calendar table, you will get everything as 12:00:00 AM. So, if the times don't match up, no relationship. I'm guessing this is the issue. So, you would want to create a column in each table that is only the date or you would create a column in your Project table that is the date with a time of 12:00:00 AM and use that as the relationship to your Calendar table.
I formatted the dates as Date in report view but not in the Query Editor. After formatting them as Date in the Query Editor the issue went away. Thanks for your help!
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 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |