Forum Discussion

viwinski7's avatar
viwinski7
Frequent Visitor
5 years ago
Solved

Issue with Timezone Conversion

Hi all,    So I am having the hardest time with converting my power bi Reports to Central time. I have changed the time zone using DateTimezone.Switch Zone, looked through all of the forums, but I ...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    viwinski7 ,Based on what I got from the problem

    You have utctoday() and utcnow(), that you can use and add time to get your time zone

     

    new =

    var _1= utcnow() + time(5,30,0)

    return 

    date(year(_1), Month(_1), day(_1))

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

viwinski7 ,Based on what I got from the problem

You have utctoday() and utcnow(), that you can use and add time to get your time zone

 

new =

var _1= utcnow() + time(5,30,0)

return 

date(year(_1), Month(_1), day(_1))

 

  • viwinski7's avatar
    viwinski7
    Frequent Visitor
    5 years ago

    Thank you for your insights. However, when I do this, I'm still getting data that was captured from the previous day. So instead of 31 exits from our facility, I am still getting 36. . . because last night after 7pm there were 5 more exits. how do I make it so it's only counting the number of exits between 12a-12a in Central time? 

     

    here is my updated code: 

     

    Coalese(Countrows(Filter('Census', [Exit Date]. [Date] = DATE (Year(Var_1), MONTH (Var_1), DAY(Var_1)))),0)