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!
I 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)
This is seriusly messing with my head.....
Create a new page
Remove any report level filters
Add a table
Add only the date column and the other column it has a relationship with.
Post results
Otherwise, if you can share the file, it would be the easiest way :p
Will have to find a file sharing solution.
Meanwhile tex628 I did what you asked:
no report level filters
just showing you the visual filters
And here also the relationship:
Here are links to 2 files:
the pbix: https://drive.google.com/open?id=1dO125L_8IXHSrDtK6Bn-BNan91RMCvzY
the sql table: https://drive.google.com/open?id=1H0nh9mPEBwIUH1SeAEG3OF2jhR6Ayasl
Hope they work.