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!
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.
This is really really weird. If you have an email that is somewhat anonymous you can email me the file, otherwise just give me a heads up when you got the filesharing sorted!
Links see my post above yours ;-)