Forum Discussion

kaka's avatar
kaka
Helper II
9 years ago
Solved

How to subtract hours from DateTime data using DAX?

I am creating a new column using DAX where I need to display a date by subtracting five hours from it.    So, if my date is 2016-12-21 09:40 pm, it should be 2016-12-21 04:40 pm.  The function...
Need Help
  • danrmcallister's avatar
    danrmcallister
    9 years ago

    Try this in DAX:

     

    MaxDateFiveHourDiff = MAX(Table1[DateTime]) - 5/24

     

Shamsbutt's avatar
Shamsbutt
Helper II
6 years ago

Create new column with following Dax

Column = 'DateTime'[YourColumn] - TIME(0, 5, 0)
Hope it'll help. 
  • himuengg's avatar
    himuengg
    Frequent Visitor
    3 years ago

    this works like a magic. thanks. however, the TIME format is TIME(HH,MM,SS)