Forum Discussion
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...
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
I have. That was that is what I am mentioning in attempt number 2 above.
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
This worked! Thank you! Along with making sure I was using a measure function to calculate count rather than allowing PowerBI to calculate it for me.
Cool!