Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to set timeZone using pbi parameters

I would like to create a report that has dynamique date gestion.   My need it to pass the timezone offset via a parameter. then generate a new date column based on UTC column + Timezone offset para...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous,

    I think you can add a user table that includes the user and date timezone offsets, then you can add a new column to your date table to calculate correspond datetime based on current date time fields and user timezone offset.

    If you do not have these timezone offsets, you can also use the query parameter and 'datetime.addzone' function to change datetime based on timezone parameters..

    DateTime.AddZone 
    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous,

I think you can add a user table that includes the user and date timezone offsets, then you can add a new column to your date table to calculate correspond datetime based on current date time fields and user timezone offset.

If you do not have these timezone offsets, you can also use the query parameter and 'datetime.addzone' function to change datetime based on timezone parameters..

DateTime.AddZone 
Regards,

Xiaoxin Sheng