UTC TODAY CHANGE HOUR

[feralvarez994]

Hi everyone! I have an issue here

I have published a report in PBI Service that have some dax formulas with TODAY(). The thing is that at 21 o'clock in Argentina, the values return 0 because it changes the day in Service, but in Argentina its still the day before for 3 hours else. I need PBI Service to manage the day as it is in Argentina (from 00:00 to 23:59 Argentina timezone) that it's from 03:00am to 02:59am UTC time (Argentina is -3 UTC Time).

I have a column (DEMORA RVA) that counts the delay (in days) between today and the booking day, so when

- Delay is 0 =   booking day -> TODAY 

- Delay is 1 =  booking day -> Yesterday (in working days)

The DAX formulas that i use

DEUDA NUEVA AYER =

VAR asd =            CALCULATE (SUM ( RESERVA[RE_SALCONT] ), RESERVA[DEMORA RVA] = 1)

RETURN                 IF ( ISBLANK ( asd ), 0, asd )

I dont have the hour in the date column, only the date. How can I change the today in PBI Service so it shows today in LocalTimeZone?

thank you all!

[v-rongtiep-msft]

Hi @feralvarez994 ,

Current power bi service only support UTC datetime. It not contain any features can auto transform datetime based on location.

Maybe you can vote at below idea submitted by other user:

Handle local time zone in Power BI service

I have also found a similar post, please refer to it to see if it helps you.

display date/times in local timezone rather than UTC 

• you can create a custom column in Query Editor  DateTime.LocalNow() and #duration() function.

https://docs.microsoft.com/en-us/powerquery-m/sharpduration 

For example:

DateTime.LocalNow()+#duration(0,2,0,0)

changing timezone of powerbi service? 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[otravers]

TODAY() in the Power BI service is always computed against UTC so you'll have to add offset logic in your report.

https://docs.microsoft.com/en-us/dax/now-function-dax