Forum Discussion

Eesa's avatar
Eesa
Frequent Visitor
4 years ago
Solved

DATEDIFF

Hi  I want to calculate the difference between two dates in DATE/TIME format and return the difference in MINUTES.  the DAX formula as follows: DateDiff = DATEDIFF(TABLE[Start Date],TABLE[E...
  • adi_dasturkar's avatar
    adi_dasturkar
    4 years ago

    Please Write below Formula
    DateDiff = DATEDIFF(TABLE[Start Date],TABLE[Ended On],MINUTE)

    Note - Remove .Date from [Ended On]

    Please Accept a Solution if you solved it.

adi_dasturkar's avatar
adi_dasturkar
Regular Visitor
4 years ago

Please Write below Formula
DateDiff = DATEDIFF(TABLE[Start Date],TABLE[Ended On],MINUTE)

Note - Remove .Date from [Ended On]

Please Accept a Solution if you solved it.