Forum Discussion
Relationship problem between date columns from 2 tables
I have 2 tables:
- 1 table "SubprojectsAll", loaded from sql via directquery, contains a date column named "Date last primary proposal revision" (formatted in Power BI as date)
- 1 table "Dates" I created with calendarauto(12)
Also created a many to one relationship between these columns:
I can create a table view showing the dates from SubprojectsAll
Same for the Dates table (though I wonder why I can't show the date itself and only the dateparts):
Now when I try to create a table view by combining both I get a blank result:
For some reason the relation doesn't work (at least appears so to me). I have similar issues creating charts, slicers etc. When ever I use the "Dates" data I get a blank result.
Please can you explain what is going wrong.
And furthermore, it has to be done in the query editor. Does not work if you attempt to do it from the normal modelling pane!
27 Replies
Hi WimVan ,
I would suggest you checking the date format of your date column, I found it is strange that the date comes with the 1900 when you are using the CALENDERAUTO() function, actually, this problem often occurs when the year and month are recognized wrong.
If possible, you can share a sample pbix without personal information to us for analysis.
Best Regards,
Teige
you need to write click on date field and then choose date instead of date hierarchy in values field.
When i try date/time first i get the same error:
