Forum Discussion

sclement's avatar
sclement
Regular Visitor
3 years ago

Today's Date

Hi All,

I am from Australia and I am working with the Date Slicer for my Powerbi Report. (Needs to be in Australian date (UTC +10) when published to the service)

 

For the Date, I am considering a 'calendar' table as below:

Calendar("01/01/2022", today()+((1/24)*10))

 

and I have a Date Slicer in my report which shows the First and last Dates. However, the problem is my last date(Current Date) is only updating to today at 10 am. 

 

Is there a way to acheive the update of today's date by 12 am itself.

 

I have been working on this for a quite long time but no luck. Any help on this is highly Appreciated. 

 

Thank you.

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    sclement , today should give you local time. you can use UTCTODAY() 

    or datevalue(UTCNOW()+ time(10,0,0))  as per need

    • sclement's avatar
      sclement
      Regular Visitor
      3 years ago

      Hi amitchandak ,

       

      Thank you for response. I will give it a go and will update you how I goes!

       

      Cheers!