CODEWITHSUNDEEP
powerpivotdaxpowerbi
PBeezy
PBeezy

Reputation: 1272

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

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?

Upvotes: 0

Views: 2080

Answers (1)

greggyb
greggyb

Reputation: 3798

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

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

Upvotes: 3

Related Questions