Hi @nico,
You could do something like this to offset a date by 9 hours from UTC
CurrentDate = Date.From( DateTimeZone.FixedUtcNow() + #duration( 0, -9, 0, 0))
As for the visual display, are you using relative datefilters? If so and its still giving you issues, you might want to switch to Offsets instead, from the code you’ve showed I can tell you’re using the legacy date table not the extended one. You can find that here.
.
This extended date table includes Offsets, which are relevant to the CurrentDate on line 5, you will need to replace the M code with the line above - as depicted here.
I hope this is helpful