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
Not in direct query mode, no. You have to return the data exactly how you need it for it to work in the model.
jdbuchanan71 - noted. thanks a ton. Appreciate your help.
jdbuchanan71 - Hi there, another quick question. I am using DirectQuery and I added another column to my view with just date and remove the timestamp. However, I am not able to see that in PoweBI desktop.