Forum Discussion

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

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)

Frequent Visitor

7 years ago

Could you check if the below one is helpful

https://community.powerbi.com/t5/Desktop/Convert-UTC-to-local-time-zone-in-DAX/td-p/43328

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))).
- Baskar
  Resident Rockstar
  7 years ago
  - 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))).
- vishnurk
  Frequent Visitor
  7 years ago
  Hi,
  
  Could you use it as a calculated column instead of measure,like below
  - 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))).