When is the data for your report last refreshed? Looking at any Power BI report this is very important to know as you wouldn't want to make decisions on outdated data. Creating a time stamp can solve this problem, however is more tricky than you might expect, because Power BI Service uses UTC time and any work around has to take into consideration daylight saving time. In this video I show you how to create the ultimate time stamp. Enjoy the video and subscribe for more Power BI tricks!

Download file here datatraining.io/powerbi-how-to

--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powerbidesigntransformation

Power BI Essentials datatraining.io/powerbilearningpath

Business User Training datatraining.io/powerbi-business-users

For Custom Trainings and Consulting email directly support@datatraining.io

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:57 Showing the current date and time
02:39 UTC time problem in Power BI Service
03:18 Showing the local refresh date and time in Power BI Service
05:32 Summer time starts when? Finding the second or last Sunday in a month
10:30 Dealing with daylight saving time
14:48 End

---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO​
Insta instagram.com/howtopowerbi/
LinkedIn linkedin.com/in/basdohmen/
TikTok tiktok.com/@how.to.power.bi
X twitter.com/HowToPowerBI
fb facebook.com/groups/howtopowerbi
Threads threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos epidemicsound.com/referral/8pjcbj
🚀 For growing on YouTube: tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

• The ultimate TIME STAMP in Power BI | UTC and Daylight Saving Time FIX ( Download)
• NEVER GET THE WRONG TIME AGAIN / Switch Time Zones and Clock Changes in in your Power BI Reports ( Download)
• Showing Specific Timezones in Power BI Service (Last Refreshed Time) ( Download)
• Easy Time Zone Conversion in Power BI ( Download)
• How do you get a REFRESH DATE in your Power BI report ( Download)
• Create Last Refresh Time that respects Daylight Saving in Power Query ( Download)
• Change Time zone in Last Refresh Date in PowerBi | MiTutorials ( Download)
• Just store UTC Handling Time Zones & Daylight Saving ( Download)
• How to Add Last Refresh Date & Time in PowerBI | MiTutorials ( Download)
• Power BI: Show Last Refresh - Using UtcNow ( Download)
• Creating a Last Refreshed Time Stamp in Power BI ( Download)
• Mastering Last Refresh Timestamps in Power BI with Time Zone Precision ( Download)
• Showing LAST REFRESH in Power BI #Shorts ( Download)
• Unpacking the Auto date/time option in Power BI : What you need to know ( Download)
• Avoiding Issues When Generating Time/Date in Power BI ( Download)