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 lbendlin , 

 

Yes - I used DAX to add a new column with the adjusted date, when that didn't work, I used the local date function in power query to create a column from examples with the local time.. 

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi ashleylinkewich ,

 

Could you pls take a screeshot of your custom column about converting to the UTC time and what is showing in Service?

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
  • 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