NEVER GET THE WRONG TIME AGAIN / Switch Time Zones and Clock Changes in in your Power BI Reports

In this video we're going to look at how you can switch time zones, how to respect clocks moving to ensure that you're always showing the right time in your Power BI reports

🕓 TIMESTAMPS
0:00 - Intro
00:39 - DAX Get Latest Date
03:16 - Power Query Last Refresh Date
05:24 - Issues with Tenant Date Time
06:51 - Fix Time Zones
08:50 - Fix when Clock Changes
16:38 - Summary

-

📣 Get Demo Files HERE

🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.

📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more

🛒 Power BI TEMPLATES and more at our digital shop

❤ Other ways to SUPPORT us

📧 GET IN TOUCH

🤝 SOLUTIONS ABROAD
Hi Power BI fans, my name is Fernan. In 2018 I founded Solutions Abroad to help fellow data enthusiasts learn Microsoft’s tool, Power BI. I’m currently based in London with over 8 years of experience working with data and business intelligence. In this channel I provide educational videos about Power BI including tips and tricks, step by step tutorials, news, and all of it for FREE. I also provide some paid content such as courses, templates as well as consultancy services.
If you like what we’re doing here and would like to support, consider purchasing something or donating through our Patreon, every little penny helps us keep the channel going.

🙏 THANK YOU
Thank you so much for checking out my channel and my videos. You, the community, have been instrumental in growing the channel to where it is now. Hope to see you again on my next video!

#PowerBI #DataAnalytics #BusinessIntelligence

[parranoic]

By far the best explanation on Youtube

[Coco-lrsc]

Hey Fernan thanks for the video. I appreciate you explained it in a very clear and easy to understand. One thing I think worth point out is that for the Time in Philippines column, as soon as you change its type to Date Time, it shows your local time instead of the real time in the Philippines. I see that happen in my report as well.
Any chance you can revisit this video and update new tricks for this please?

[luizanishi]

Wooooww, This video saved me! Thanks for sharing :)

[malli]

When converted to datetime this doesnt work again it get back to local time and in power bi service also showing wrong time

[matthewmansmoviesinminutes]

Still doesn't seem to work once published to the service unfortunately :(

[TheSoulWithin]

Awesome! Very clear! Is there a way to make it into a function? I have a column that contains date/time/timezone and I want to add a new column that would each row to a different timezone?

[lwigywq]

Dear Fernan, Thank you for your consistently interesting and very useful content. It's always a pleasure to watch your videos. Today I have a question regarding the number format in the service area. I create my reports in Germany in the desktop version. Number format is decimal comma and thousand point. When I publish the report in the service area, the number format changes to decimal points and thousand commas. Do you have an idea how I can also display the original number format in the service? Thank you for your effort and good luck with your posts. Best regards Andrew

[rafaelosipov]

Great Video, thank you, Fernan!
Q - if I get my data from another source, SnowFlake in my example - then it converts in Power BI to where the PBI data is stored at?

[hamzasaud]

this doesnt work as if you note @ 08:42 when he converts into Date/Time format. it changes to local date and time.

[jnrradgrupe]

formatDateTime(parseDateTime(split(convertTimeZone(triggerOutputs()?['body/receivedDateTime'], 'UTC', 'Singapore Standard Time'),  '+')[0]),  'M/d/yyyy h:mm tt',  'en-US')

what's the difference from switch timezone or it can be used together? Newbie here.