Forum Discussion
Relationship problem between date columns from 2 tables
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!
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
Thanks for your reply TeigeGao. Unfortunately I don't see any menu item to attach a file here in my message editor...
You can share it via Onedrive
The fact that you are getting 1900 dates in your datetable implies that you calendarauto() isnt working as intended.
I would just advice you to do aCALENDAR(DATE(2010,1,1),TODAY())
instead. Then make sure the column is in plain date format.
WimVan
Swap the 'date hierarchy' to date:
And if you want to upload a file, you need to do it through another service. Cant be done through the community website.
Br,
JI think the 1900 dates were coming from the fact that one of my tables had a column with dates of that year.
After I removed those dates the calendarauto generated dates from 2000 onwards.
Anyway, I tried your suggestion with
CALENDAR(DATE(2010,1,1),TODAY())
and also swapped hierarchy to "date".
Columns in both tables have data type "Date" and format "yyyy-MM-dd"
Still I get an empty view (see the one to the right)