Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
Hi @jracer007,
You can change data type in Query Editor mode.
Best regards,
Yuliana Gu
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.
How did you unite them?
Thanks, I'll try with that if it works.
It marks me error in the fields.
Hi @jracer007,
What error message did you get? What is the date formate like in Google Analytics?
Regards,
Yuliana Gu
The format is yyyyMMdd
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |