title: Power Bi DAX: Relative Date Filtering
body: <p>I have a quick question, is there a way to filter data from set days between 2 months?</p>
  
  <p>E.g filter from 16-15 of Jan-Feb.</p>
  
  <p>Is this possible?</p>
  
  <p>For example i have used a measure to calculate days between dates</p>
  
  <pre><code>Last Assessment 16-15 
      = CALCULATE(SUM('Table1'[Duration1]),'Table1'[Start], 
               DATESBETWEEN('Calendar'[Date], [Assessment Date], [Assessment one month]))
  
  Assessment Date = if(DAY(TODAY())&lt;16,DATE(YEAR(TODAY()),MONTH(TODAY())-1,15),
                        DATE(YEAR(TODAY()),MONTH(TODAY()),15))
  
  Assessment one month = EDATE([Assessment Date],-1)+1
  Assessment 6 = EDATE([Assessment Date],-6)+1
  Assessment 12 = EDATE([Assessment Date],-12)+1
  </code></pre>
  
  <p>The last assessment does show from the 16th of 2 months ago to last months 15th e.g Dec 16th - Jan 15th.
  But i need to show from last 6 months and the last 1 year.</p>
  
  <p>How can i work this out so i can show the Last 6 months and 1 year.</p>
  
  <p>So far i have had to use a date filter to manually select the dates which i want to stop and have it be automatic.</p>