Forum Discussion
Delta between two dates
Hello folks, I'm trying to calculate the delta between two dates, I'm sending the The File . Is there a better way to do it? Can anyone help? Thanks!
You need to disconnect your date tables, and use USERELATIONSHIP()
see attached
Inbetween = CALCULATE(sum('Fact'[Sales]),DATESBETWEEN('Fact'[Date],min(CalendarFact[Date]),max(CalendarFactDest[Date])))You would add a second rule from 0 to max.
Delta in what currency? Days? Months? Years?
I'd like to see the result for this calculation
You need to disconnect your date tables, and use USERELATIONSHIP()
see attached
Awesome!
Just as curiosity, do you think we can have the comulative sum between selected months? 🙂
Inbetween = CALCULATE(sum('Fact'[Sales]),DATESBETWEEN('Fact'[Date],min(CalendarFact[Date]),max(CalendarFactDest[Date])))