title: Calculating days a case is active between two dates
body: <p>I need help solving a problem. I am trying to calculate active days a case was open between two dates in PowerBi. Sample table would be something like this</p>
  <p><a href="https://i.stack.imgur.com/OgAWL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OgAWL.png" alt="enter image description here" /></a></p>
  <p>We would like to be able to visualize how many cases were active in certain month and compare it to the previous years. I have tried many ways to complete this and failed. Any thoughts?</p>