Forum Discussion
jracer007
Helper IV
Helper IVDate format Google analytics
Hello Community, I wanted to ask you how I change the format of the Google Analytics dates so that the Power BI does not recognize it as a number.
I've used a long way: get 3 separate columns: day, month, year.
Convert them into text.
Merge into single column with dots or dashes between columns.
Convert into date format.
v-yulgu-msft
Microsoft Employee
Microsoft Employee
jracer007It marks me error in the fields.
- v-yulgu-msft
Hi jracer007,
What error message did you get? What is the date formate like in Google Analytics?
Regards,
Yuliana Gu
- jracer007
The format is yyyyMMdd
I've used a long way: get 3 separate columns: day, month, year.
Convert them into text.
Merge into single column with dots or dashes between columns.
Convert into date format.