Forum Discussion
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 ...
Why not add the column in Query Editor instead of in DAX?
Add Custom Column:
[TimeColumn] + #duration(0,6,0,0)
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.
Why not add the column in Query Editor instead of in DAX?
Add Custom Column:
[TimeColumn] + #duration(0,6,0,0)
Many thanks for the help!