title: How to use a single date table for two date fields?
body: <p>I'm using Power BI Desktop to explore some data. I have a table called "Reports" which contains a list of reports that need to be filed. There are two date fields, "Due Date" and "Date Completed".</p>
  
  <p>I have a single date table, Dates. It has been marked as my date table in Power Bi.</p>
  
  <p>My goal is produce a matrix where each row is a month in the due date and each column is a month in the date completed. However, I can't figure out how to get Power BI to use the dates table for both of my date fields. I can join it in the relationships pane - but it looks like I can have only a single active relationship at a time.  I've also tried the "Get Data" feature to add the date table multiple times, but it will only add once.</p>
  
  <p>How can I use my date table for more than one date field at a given time? </p>