Forum Discussion
Google Big Query date
Well I have 2 isses with Google Big Query.
One was I keep trying to make a change to my code where I added the dataset and it is just saying waiting for google big query for hours.
Since it is not working, I was wondering if you could help me fomat the date in PowerBI instead. Currently, I am unable to join the date to my calendar table because the date I have is Date Time or Date which is in a weird format. Currently it shows as 20220120 and I need it to be like 28/01/2022. Can you help with both or at least one of these issues? Thanks!
Hi, jnrezk
Select the column and choose Change Type from the right-click menu.
Use Change Type with LocaleIn the sample example, select the locale that works for you.
Hope this helps.
Best Regards,
Community Support Team _ Zeon ZhengIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
jnrezk , A new column in Power Query
= Date.FromText([Datecolumn])
or
= #date(Text.Start([Datecolumn],4), Text.Middle([Datecolumn],4,2),Text.End([Datecolumn],2) )
amitchandak Do you mind being a bit more specific in your examples - like what do I change out of what you sent - it doesn't work ...
DateText = Date.FromText([Is this date my date in the data set?])
this is what I tried and it won't work
Hi, jnrezk
Select the column and choose Change Type from the right-click menu.
Use Change Type with LocaleIn the sample example, select the locale that works for you.
Hope this helps.
Best Regards,
Community Support Team _ Zeon ZhengIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This was an easy and very useful fix thank you!
