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.
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!
Solved! Go to 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.
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.
This was an easy and very useful fix thank you!
@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 ...
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 |