Forum Discussion

ESS's avatar
ESS
Regular Visitor
6 years ago
Solved

Duration.Seconds difference between two dates

I am trying to extrapolate the seconds between two dates using the function Duration.Seconds   Duration.Seconds([taglio_data_ora_fine]-[taglio_data_ora_inizio])   in some is correct in others not...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi ESS ,

     

    I think you want to calculate the difference between two dates. You can try DATEDIFF() function in the DAX.

    Column =
DATEDIFF ( 'Table'[taglio_data_ora_fine], 'Table'[taglio_data_ora_inizio], SECOND )

    Best Regards,

    Eads

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi ESS ,

 

I think you want to calculate the difference between two dates. You can try DATEDIFF() function in the DAX.

Column =
DATEDIFF ( 'Table'[taglio_data_ora_fine], 'Table'[taglio_data_ora_inizio], SECOND )

Best Regards,

Eads

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.