Difference between two dates returns date instead of number [DAX]

0
votes

In PowerPivot DAX formulas, I need the number of days between two dates.

My formula is 

ProjectDays:=[ProjectFinish]-[ProjectStart]

But instead of a number, it returns a date.

enter image description here

Any ideas?

1
powerpivotdaxpowerbi

1 Answers

3
votes

ProjectDays:= VALUE( [ProjectFinish] - [ProjectStart] )

VALUE() is the poorly named 'convert to numeric type' function.