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.

 

Arun1's avatar
Arun1
Frequent Visitor
8 years ago

could you tell name of the function used here?