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)

Baskar's avatar
Baskar
Resident Rockstar
7 years ago

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Baskar,

I used Tijd = 'EZproxy log'[Tijd_VS] + TIME(6,0,0) as a new column and got this error: The syntax for '.0' is incorrect. (DAX('EZproxy log'[Tijd_VS] + TIME(6.0.0))).

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

    You could try this formula:

    Measure = CALCULATE(SUM(Table1[Tijd VS]))+6/24

    Result:

    You could also download the pbix fiel to have a view.

     

    Regards,

    Daniel He