Forum Discussion
Solved
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 ...
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!
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:
