Date calculation

[Anonymous]

Hi

Can any one please help me on how to calculate date difference from effictive start and effective end dates in DD/MM/YYYY format to use as date hierarchy filter 

[ray_aramburo]

Hi, USe this formula when creating a new column; Days_Difference = DATEDIFF(TableName[EffectiveStart], TableName[EffectiveEnd], DAYS)

[Anonymous]

Hi @ray_aramburo I am looking for difference in date in dd/mm/yyyy format not days.

[ray_aramburo]

A difference between two dates is a single scalar value. I'm not sure which criteria would you use to define what day, month or year you expect there.