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!
Thanks for your reply TeigeGao. Unfortunately I don't see any menu item to attach a file here in my message editor...
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,
J
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)
Hi WimVan ,
You can share the pbix file via Onedrive, then we can get more detailed information about this problem.
Best Regards,
Teige
I have onedrive for business (from employer). I can share links to onevirtualoffice users but the url of the link contains my name...
This is seriusly messing with my head.....
Create a new page
Remove any report level filters
Add a tableAdd 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 :pWill have to find a file sharing solution.
Meanwhile tex628 I did what you asked:
no report level filters
just showing you the visual filters
