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/Tim...
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

     

     

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity 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