Forum Discussion
Inactive relationship Date vs Create_Date
Thank you for sharing. The problem is, your Created_Date has a time stamp on it so there are no matching rows in the 'Date'[Date] column.
When you get it from the direct query source do a CONVERT(Date, Created_Date) on it and it should work. That will drop the time portion.
Hi jdbuchanan71 - Thank you for sharing the file. However, it did not work. You can see the months are not showing plus you made create_date to active relationship.
This is how I want to see in the table-
Date (from Date table) Revenue by Close date Revenue by Create_date 3/5/2022 $100 $200 3/1/2022 $500 $190 12/25/2021 $1000 $2000
Hi jdbuchanan71 - Thank you for sharing the file. However, it did not work. You can see the months are not showing plus you made create_date to active relationship.
This is how I want to see in the table-
| Date (from Date table) | Revenue by Close date | Revenue by Create_date |
| 3/5/2022 | $100 | $200 |
| 3/1/2022 | $500 | $190 |
| 12/25/2021 | $1000 | $2000 |
I updated the attached file by making a new column in the data sample table [CREATED_DATE_date_only]. Then modified the links and adjusted the USERELATIONSHIP formula to point to the new column. When CREATED_DATE is just a date with no time you can see it works.