Forum Discussion
Inactive relationship Date vs Create_Date
Hi All, I have two tables: Date Opportunity The Opportunity table contains many different date columns, including: Close Date (active relationship with Date Table) Created Date (in...
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
I made create date the active relationship to test the file. The problem needs to be fixed on the direct query side. You need to change your query to only return the DATE portion of the CREATED_DATE.