Get date difference

Marcelo_Ignacio_Cid1 · November 29, 2021, 3:13pm

I need how can i get the difference between two dates.
asda

I am currently trying this code but it has not worked for me
DateDiffDays([Measures].[Issue Start Block],[Measures].[Issue End Block])

zane.baranovska · November 29, 2021, 3:48pm

Hi @Marcelo_Ignacio_Cid1,
you are on the right track! DateDiffDays() is the correct function to calculate the duration between two dates.

You might want to set measure formatting to Numeric value to show the number of days: (Calculated measures and members)[Calculated measures and members].