Forum Discussion
Solved
Date 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.
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