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

     

kaka's avatar
kaka
Helper II
9 years ago

Ok, so that would be an unnecessary column for me because what am actually doing in DAX is grabbing the maximum date from the table and then subtracting it's hour by 5. So, am creating a column called MaxDateFiveHourDiff: 

 

MaxDateFiveHourDiff = MAX(due_date) - 5 hours. Question is, how do you subtract the 5 in DAX ? 

danrmcallister's avatar
danrmcallister
Resolver II
9 years ago

Try this in DAX:

 

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

 

  • kaka's avatar
    kaka
    Helper II
    9 years ago

    Fantastic. Thank you. 

  • jfreyha's avatar
    jfreyha
    Frequent Visitor
    6 years ago

    I actually came here looking for someone to explain this. how does the -5/24 or +8/24 works? is it supposed to be ashortcut for datediff? can it work for days/weeks/months/years...etc?

    Thanx