title: Power BI visualization of data with a Start and End date
body: <p><a href="https://i.stack.imgur.com/02fmg.png" rel="nofollow noreferrer">THis is an example of what I think i need to do</a></p>
  
  <p>I would like to ask some modeling advise I cannot solve myself:</p>
  
  <p>I am using Power BI to visualize the time machinery is out of order.
  The source is a register of equipment not functioning, with a start date and end date (note that there is no end date if the machine is not fixed yet).</p>
  
  <p>I would like to show the time (hours, percentage, etc) that the machinery is out of order, filter for a specific period /date (e.g. month).</p>
  
  <p>So I have 2 date columns: ‘’Start out of order’’  and ‘’Back in order’’</p>
  
  <p>I do have a date table, which I usually would connect to all the date variables. However, since I am working with a Start and End date. This does not give the result I am looking for.</p>
  
  <p>Any help is very much appreciated!</p>
  
  <p>Kind regards,</p>
  
  <p>Link to my Power BI FILE: 
  <a href="https://wetransfer.com/downloads/83ca3850392967d0d42a5cc71f4352c420200213160932/eb7353" rel="nofollow noreferrer">https://wetransfer.com/downloads/83ca3850392967d0d42a5cc71f4352c420200213160932/eb7353</a></p>
  
  <p>Stijn </p>