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

  • Baskar's avatar
    Baskar
    Icon for Resident Rockstar rankResident 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
        Icon for Microsoft Employee rankMicrosoft 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Baskar

       

      It does work if you replace the , by  ;

       

      However it also introduces a new problem. 

      If I want to change anything in an existing column via edit queries I get an error back that there are more columns than expected.

       

       

      • Chihiro's avatar
        Chihiro
        Icon for Solution Sage rankSolution Sage
        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))).