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