Add 1 hour to a date/time field in tabular model

DAX DAX Calculations
1

Hi,

apologies, for not posting a model or anything, is there an easy way to add one hour to a date time field in DAX in a tabular model?

2

Hi @DavieJoe. Does adding 1/24 to the datetime help?
Greg

1 Like
3

@DavieJoe ,

Try this as a calc column:

DatePlus1Hr =

Dates[Date] + TIME( 1,0,0)

  • Brian
4

@Greg Thanks for confirming this, this popped into my head just after posting (Honest). I suggested to my colleague that he add one hour to the Date Time field and he didn’t think it would work…I was sharing my screen when your reply came up…he then tried it and was like “oh…that does work actually”…remembering that date time is basically a number is helpful.

Thanks again.

1 Like
5

Hi @DavieJoe, did the response provided by the users and experts help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

I hope that you are having a great experience using the Support Forum so far. Kindly take time to answer the Enterprise DNA Forum User Experience Survey, we hope you’ll give your insights on how we can further improve the Support forum. Thanks!

1 Like
6

Apologies; I thought I had accepted Greg’s suggestion as the solution, updated now.