Forum Discussion
Calendar use
Hi Anonymous ,
I see your date column has a format of 'yyyy-mm-dd HH:MM:SS UTC' and per my testing, that doesn't play well in PowerBI. What you can do is import it as text, create a new column based on that dateComplete column and removing the ' UTC' part of it, then change the type of the new column to DateTime.
Then create the relationship with the datetable, then drag the Date column from the datetable into your visual and that should work.
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Hi Anonymous ,
Just like djerro123 said, Power BI couldn't resolve the values to dates if the format was incorrect.
For example, 10/1/2019 would be October 1 2019 , 1/10/2019 would be January 10 2019 and 25/12/2019 would throw an error if your Locale for import is set to English(United States).
It would be better if you could share some sample data about "dateCompleted" and calendar[date] to us.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
Anonymous JarroVGIT i changed the settings to English(Europe)
Here's a screenshot of the calendar and a screenshot of the datecompleted column from the data warehouse. still doesn't work.DateCompletedCalendar
- JarroVGIT
Resident Rockstar
Hi Anonymous ,
I see your date column has a format of 'yyyy-mm-dd HH:MM:SS UTC' and per my testing, that doesn't play well in PowerBI. What you can do is import it as text, create a new column based on that dateComplete column and removing the ' UTC' part of it, then change the type of the new column to DateTime.
Then create the relationship with the datetable, then drag the Date column from the datetable into your visual and that should work.
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
- JarroVGIT
Anonymous did this solve your issue? Please mark it as the solution so others may find the answer to the same issue. Thanks