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)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

Get this error when I try it as new measure.

So no, doens't work.

 

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))).

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))).