Forum Discussion

PowerrrBrrr's avatar
PowerrrBrrr
Icon for Helper III rankHelper III
4 years ago
Solved

What's the alternative to use with Direct Query?

So I have table with [TimeStamp] in it and I have created a custom column with below formulae =DateTimeZone.RemoveZone([TimeStamp])+#duration(0,3,0,0) , but this custom column was allowed in Im...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    PowerrrBrrr 

    Of course you can do that in dax, you may create the measure in Direct Query mode.

     

    Measure = MAX([DateTime])+TIME(3,0,0)

     

    Best Regards
    Paul

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

PowerrrBrrr 
In this case you can just + 3 hours to the timestamp column. Direct Query just does not support the timezone function, which is not necessary.

=[TimeStamp]+#duration(0,3,0,0)

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

PowerrrBrrr's avatar
PowerrrBrrr
Icon for Helper III rankHelper III
4 years ago

this is a measure what you have created ? I dont get the result when I create a measure.