Google Big Query date

[jnrezk]

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!

[v-angzheng-msft · Accepted solution]

Hi, @jnrezk 

Select the column and choose Change Type from the right-click menu.
Use Change Type with Locale

In the sample example, select the locale that works for you. 

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jnrezk]

This was an easy and very useful fix thank you!

[amitchandak]

@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) )

[jnrezk]

@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