Forum Discussion

giovanna8988's avatar
giovanna8988
Frequent Visitor
3 years ago
Solved

Calendar Table Not Connecting With Direct Query

Hello,   I am trying to relate my calendar table to a data set from a direct query, but my relationships are not matching. I am pretty certain it has to do with the fact my data set has date/time f...
  • jewel_at's avatar
    jewel_at
    3 years ago

    Oh Sorry!

    How about try this in your SELECT COLUMN, then change the data type to Date

     

     

    Left(CONVERT('Table'[Timestamp], STRING),10)

     

     

    This is given that your original date is mm/dd/yyyy hh:mm:ss

     

    Do you have a sample of your data?

     

    Jewel

     

jewel_at's avatar
jewel_at
Resolver I
3 years ago

Hi giovanna8988 

 

Have you tried changing the data type of the date from your SELECT COLUMNS to "Date" ? Select the field >> Column Tools

 

 

Hope that helps!

Jewel