Forum Discussion
Joint time data field between fact table and time table
Hi experts,
I am having trouble trying to create a joint between a time field (directly from SQL using DirectQuery) where I am not able to change the data type. I have created a time table where I try to create a similar structure (eg, d/m/yyyy hh:mm:ss) and attempt to perform a joint but I kept getting an error saying the column either doesn't exist or doesn't have a relationship. Can I know where did I go wrong?
Fact Table
Time Table
Attempted Joint
2 Replies
- amitchandak
Super User
jlhy , related will not work in a new column. Just have the hour bucket in time table and use that in visual for display
Hi jlhy ，
You can review the reply in the following thread to get the answer for your question:
Power BI: RELATED function doesn't show related columns
What's your expected result? Do you want to add the time field into your fact table in order to create the date/time field with the format (d/m/yyyy hh:mm:ss)? Why you can't change the data type of Date field in your fact table? By the way, what is the purpose of creating such a date/time field? I'd like to see if there is an alternative way to do the same for your needs... Could you please provide the above required information? Thank you.
Best Regards
