Forum Discussion

kaka's avatar
kaka
Icon for Helper II rankHelper 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

     

danrmcallister's avatar
danrmcallister
Icon for Resolver II rankResolver II
9 years ago

kaka: What parry2k meant by saying it's M rather than DAX is that the function mentioned in the linked article was applied in the Query Editor - see below.

 

kaka's avatar
kaka
Icon for Helper II rankHelper 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
    Icon for Resolver II rankResolver II
    9 years ago

    Try this in DAX:

     

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

     

    • kaka's avatar
      kaka
      Icon for Helper II rankHelper 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