Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello all,
I have a "TimeStamp" column of datatype Time/Date that I want to offset by 2 hours from UTC to my local time zone. It needs to be Time/Date because I use it for incremental refresh, which only accepts this datatype.
I have created a new custom column called TimeStampLocal = DateTime.AddZone( [TimeStamp], 2 ) which contains the correct time, but it is of datatype Any, which isn't recognized as a date in my visuals.
If I change the datatype of TimeStampLocal to Date/Time or Date/Time/Timezone in power query, the timezone does not show in the table after saving and closing the query editor.
As soon as I am back in the Power BI desktop editor, the column has switched back to Date/Time, and in the column tool I can't change it to Date/Time/Timezone datatype.
What is going on, is this a bug or am I doing it wrong? How can I make this work?
Thanks in advance, Mike
Solved! Go to Solution.
Not familiar with that function but it does to be different than I expected. Simple fix is just to add 2 hours to your datetime columns as follows
=[DateTimeColumn] + #duration(0,2,0,0)
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Not familiar with that function but it does to be different than I expected. Simple fix is just to add 2 hours to your datetime columns as follows
=[DateTimeColumn] + #duration(0,2,0,0)
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
This worked, thank you.
User | Count |
---|---|
63 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
82 | |
62 | |
45 | |
41 | |
40 |