title: Calculate IRR from inception until slicer selection, while other metrics only for that slicer selection
body: <p>My report needs to display IRR from inception <em><strong>until</strong></em>  the year and quarter selected in the slicer, while the same report has other metrics that display <em><strong>only</strong></em> for the year and quarter selected. I'm using XIRR formula.</p>
  <p>The report has a slicer for Year, and another for Quarter.</p>
  <p>If I make a selection in the slicer for year = 2020, and quarter = Q3, the other metrics display the correct values for Q3 of 2020 (since the data in the respective tables have columns for Year and Quarter), but the IRR metric will incorrectly show me the value for Q3 of 2020. I need that card to show me the IRR up to Q3 of 2020.</p>
  <p>(For context, an IRR table usually consists of date, and the cash flow. When the asset is purchased, that date is the inception date and it has a negative cash flow associated with that date. During the life of the investment, there are cash distributions i.e. positive cash flow, and the last date consists the selling price of that asset. Hence showing the IRR for Q3 of 2020 only will result in an error, because the XIRR formula needs to see both positive and negative cash flows)</p>
  <p>I'm using the same calendar lookup table for IRR and the other metrics in my data model.<a href="https://i.stack.imgur.com/Glv2E.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Glv2E.png" alt="enter image description here" /></a></p>