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
Attached sample workbook. I am using directquery but these are the few columns present in my original table with same format.
You can see I have active relationship with close date and inactive with create date.
I want to use month from date table and find out revenue by close date as it is active relationship. I want to find out revenue by create date too with the same date field from date table. hence, I created DAX function but it isn't giving me the correct results.
Here is the link - https://drive.google.com/file/d/1Ddm96lokiGqdX2Tj9wTAyWHslEKcSw5Y/view?usp=sharing
Can you please check?