Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Time + 6 hours

Hi,   I have log files that show US server time (-6) so I need to add 6 hours to the time column in my table. I have  a "Tijd VS" column that shows the date and time (e.g. 31-8-2018 0:00:00 --> A ...
Need Help
  • Chihiro's avatar
    Chihiro
    7 years ago

    Why not add the column in Query Editor instead of in DAX?

     

    Add Custom Column:

    [TimeColumn] + #duration(0,6,0,0)

vishnurk's avatar
vishnurk
Frequent Visitor
7 years ago

Hi,

 

Could you use it as a calculated column instead of measure,like below

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi vishnurk,

 

I added a calculated column with: Tijd = FORMAT('EZproxy log'[Tijd_VS];"MM/dd/YYYY") & "  " & REPLACE(FORMAT('EZproxy log'[Tijd_VS];"HH:mm:ss"),1,2;HOUR('EZproxy log'[Tijd_VS])+6)

 

And got this error: The syntax for '.1' is incorrect. (DAX(FORMAT('EZproxy log'[Tijd_VS],"MM/dd/YYYY") & " " & REPLACE(FORMAT('EZproxy log'[Tijd_VS],"HH:mm:ss").1.2,HOUR('EZproxy log'[Tijd_VS])+6))).