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

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

     

    see attached

  • 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.  

lbendlin's avatar
lbendlin
Super User
2 years ago
Inbetween = CALCULATE(sum('Fact'[Sales]),DATESBETWEEN('Fact'[Date],min(CalendarFact[Date]),max(CalendarFactDest[Date])))
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    lbendlin
    Super User
    2 years ago

    You would add a second rule from 0 to max.  

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Nice, thanks!