Forum Discussion
Solved
USERELATIONSHIP with date not working as expected
Hello, I'm trying to do a very simple count measure with USERELATIONSHIP with my date table and column and for some reason the values are not showing. There is 100% certainty that there is a...
It does look like your Dates table is not covering the range of Opportunity[Created Date]. Please confirm that. Also, make sure your Created Date column is type Date (not DateTime); if DateTime, it needs to be changed in the query editor to type Date.
Pat
Have you made sure that both date fields are in Date Format in PowerQuery? I have this issue when one of the dates is in Date/Time format, thus it keeps trying to match only records that ocurred at the same time 12:00