Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Relationship between date columns

Hi, I have custom data connector...Have two dim tables for date and time....and want make relationship with them, from other Fact table....When type of colums for DateKey and TimeKey is Text, in Pow...
Need Help
Jimmy801's avatar
Jimmy801
Community Champion
5 years ago

Hello Anonymous 

 

you should be able to connect tables with columns that are in date-format. Ensure that both columns are setup as date-type and then connect them manually.


If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I dont want do it manually, I want Power BI auto detect them , because they already comming from connector with correct types

    • Jimmy801's avatar
      Jimmy801
      Community Champion
      5 years ago

      then try to pray ğŸ˜‰