title: Combine two fact tables from two different marts and model in create Tabular model
body: <p>I have a <strong>Fact Table Service1 (open or latest data) from Mart1</strong> and another <strong>Fact Table Service2 (historic data) from Mart2</strong>. These tables share few common measures and dimensions but the underlying dataset is mutually exclusive. </p>
  
  <p>Now the business wants to merge these two facts into one table in Tabular model to do Year over Year comparison. </p>
  
  <p>Is it possible to combine these two facts, if so, what should be the approach. </p>
  
  <p>Alternatively, do we have to achieve this.</p>
  
  <p>Things to note down are,</p>
  
  <ul>
  <li>Records in Fact table Service2 will never change</li>
  <li>The Dimension keys between Mart1 and Mart2 is <strong><em>not</em></strong> guaranteed to be same</li>
  </ul>