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.
How to add one hour to column Value below?
This is my custom step:
No matter what the second argument of the function is, nothing happens....
Solved! Go to Solution.
hi @webportal
it's best to add UTC Time Zone, and then use "DateTimeZone.SwitchZone" function of Power Query to swap to whichever time zone you want to use.
I used UTC and CEST as example. You can look up the time zones on this website (it also tells you the time difference which you will need to use to set up your parameter): https://www.timeanddate.com/worldclock/
Adding UTC Column would look like this:
From then on you need to create Parameter with however many hours the time difference will be and use the parameter to switch time zones like so:
Create another custom column to switch time zones using your required parameter and delete any columns you no longer need in the next step (UTC column for example)
End result looks like this:
hi @webportal
it's best to add UTC Time Zone, and then use "DateTimeZone.SwitchZone" function of Power Query to swap to whichever time zone you want to use.
I used UTC and CEST as example. You can look up the time zones on this website (it also tells you the time difference which you will need to use to set up your parameter): https://www.timeanddate.com/worldclock/
Adding UTC Column would look like this:
From then on you need to create Parameter with however many hours the time difference will be and use the parameter to switch time zones like so:
Create another custom column to switch time zones using your required parameter and delete any columns you no longer need in the next step (UTC column for example)
End result looks like this:
pls try this
DateTime.From(Number.From(Value) + Number.From(#time(1,0,0)))
-----------or-------------------
DateTime.From(Text.From(Value)&" "&Text.From(#time(1,0,0)))
------------or----------------
DateTime.From(Text.From(Value)&" "&Time.ToText(#time(1,0,0),"hh:mm:ss"))
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 |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |