Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculate two date/time columns

Hi,

 

I like to calculate two dates with the data type "date/time" to get the seconds between this two dates. Is there a DAX function for it?

 

So I have got a Start Date/Time and an End Date/Time. I like to get the Time in seconds between this values.

 

Best regards

Timo

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous 

    You could get it by DATEDIFF Function.

    seconds between = DATEDIFF('Table'[Start],'Table'[End],SECOND)

    For example:

    Best Regards,
    Lin

     

     

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, Anonymous 

    You could get it by DATEDIFF Function.

    seconds between = DATEDIFF('Table'[Start],'Table'[End],SECOND)

    For example:

    Best Regards,
    Lin