Take difference between two data values.
Let’s start writing some DAX!
Ok, seems simple, right? Try creating a measure DateDifference:=[EndDate]-[StartDate]
Did that work? NO? Does it return date?
Don’t worry, Here’s the solution. Try creating following DAX Measure:
That’s about it for this post. Here are some related Posts:
Calculate the difference between two dates in DAX
Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months)
NETWORKDAYS() Equivalent in PowerPivot?
One thought on “Power Pivot DAX: Difference between two DATE values”
when we add one criteria this formula do not works