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! 🙂
What error message do you get when you try to create the relationship?
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! 🙂