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