Delta between two dates

[Anonymous]

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!

[lbendlin · Accepted solution]

You need to disconnect your date tables, and use USERELATIONSHIP()

see attached

[lbendlin · Accepted solution]

Inbetween = CALCULATE(sum('Fact'[Sales]),DATESBETWEEN('Fact'[Date],min(CalendarFact[Date]),max(CalendarFactDest[Date])))

[Anonymous]

Amazing, I wish someday I'll be just as good!

[lbendlin]

Delta in what currency?  Days? Months? Years?

[Anonymous]

I'd like to see the result for this calculation

[lbendlin · Accepted solution]

You need to disconnect your date tables, and use USERELATIONSHIP()

see attached

[Anonymous]

Just as curiosity, do you think we can have the comulative sum between selected months? 🙂 

[lbendlin · Accepted solution]

Inbetween = CALCULATE(sum('Fact'[Sales]),DATESBETWEEN('Fact'[Date],min(CalendarFact[Date]),max(CalendarFactDest[Date])))

[Anonymous]

Hello there, its me again, would you know how can I set a green color font whenever the value is higher than or equal to 1? Keeping the red rule. Thanks!

[lbendlin · Accepted solution]

You would add a second rule from 0 to max.  

[Anonymous]

Nice, thanks!

[Anonymous]

Awesome!