Solved: Re: Date format Google analytics

jracer007 · ‎12-20-2017

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.

nik_yevsey · ‎01-09-2018

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.

View solution in original post

nik_yevsey · ‎01-09-2018

The same for me - date from Google Analytics comes in YYYYMMDD format and I cant find locale or some handy way to convert it into data type in PBI

v-yulgu-msft · ‎12-20-2017

Hi @jracer007,

You can change data type in Query Editor mode.

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

nik_yevsey · ‎01-09-2018

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.

jracer007 · ‎01-11-2018

How did you unite them?

power bi7.png

jracer007 · ‎01-09-2018

Thanks, I'll try with that if it works.

jracer007 · ‎12-21-2017

It marks me error in the fields.

v-yulgu-msft · ‎12-31-2017

Hi @jracer007,

What error message did you get? What is the date formate like in Google Analytics?

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.