how to add 1 day to my date time column

[Anonymous]

Hi,

if i use dateadd function in DAX ,it is considering next day 12 AM(if i add 1 day),but i need with hours also, the hours are not showing ,by default it showing 12 AM for next day,how to show with hours.

Regards

Mallikarjunarao 

[v-sihou-msft · Accepted solution]

@Anonymous

In DAX, when using DATEADD() function, it will return a column of dates so that the timestamp will be truncated into 12 AM. I suggest your directly "+1" on your date/time column.

Regards,

[Anonymous]

Thanks Simon,

i got solution,

same time if i want add hours,months and years,

Can you please provide solution for this as well,it will helpfull to me.

Regards

Mallikarjunarao

[BenMcChesney]

I found this Date.AddDays( date , number ) worked great! There are a bunch of other methods as well. https://msdn.microsoft.com/en-us/library/mt296606.aspx