Forum Discussion

ashleylinkewich's avatar
ashleylinkewich
Advocate II
6 years ago

Date Changing When Published To Service - despite coding it out with dax

Hi everyone,    While I have had this same issue before, the previous solution doesn't seem to be working.    My database (CDS) stores dates in UTC timezone, and I am in AEST (+10). While it disp...
Need Help
ashleylinkewich's avatar
ashleylinkewich
Advocate II
6 years ago

Hi v-kelly-msft 

 

Please see below screenshots. I have created a new column using DAX to create my local time column as pictured. DAX

 

Incorrect Date

Incorrect Date (published in service) pictured above 

Correct DateCorrect Date pictured above 

  • ashleylinkewich's avatar
    ashleylinkewich
    Advocate II
    6 years ago

    Hi v-kelly-msft 

     

    I used DateTime.AddZone([Date],10) which seems to work for all of my other reports, but not this one.... Do you have any other suggestions? 

     

    Thanks!