Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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!

 

 

Need Help
Show and Tell
  • lbendlin's avatar
    lbendlin
    2 years ago
    Inbetween = CALCULATE(sum('Fact'[Sales]),DATESBETWEEN('Fact'[Date],min(CalendarFact[Date]),max(CalendarFactDest[Date])))
  • lbendlin's avatar
    lbendlin
    2 years ago

    You would add a second rule from 0 to max.  

10 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      I'd like to see the result for this calculation

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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