Forum Discussion
Calendar Table Not Connecting With Direct Query
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
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
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!