title: Fiscal year in power bi
body: <p>I want to create fiscal year from start-date 01-Jul-2015 to end-date  30-Jun-2017</p>
  
  <p>i have this code now i modified this code according to the give fiscal year </p>
  
  <pre><code>Cal = 
  ADDCOLUMNS (
     CALENDARAUTO ( 3 ),
     "MIndex", MONTH ( EDATE ( [Date], -3 ) ),
     "CalMonth", FORMAT ( [Date], "mmm" ),
     "CalQtr", "Q"
         &amp; CEILING ( MONTH ( [Date] ), 3 ) / 3,
     "CalYear", YEAR ( [Date] ),
     "FinQtr", "Q"
         &amp; CEILING ( MONTH ( EDATE ( [Date], -3 ) ), 3 ) / 3,
     "FY",
     VAR CY =
         RIGHT ( YEAR ( [Date] ), 2 )
     VAR NY =
         RIGHT ( YEAR ( [Date] ) + 1, 2 )
     VAR PY =
         RIGHT ( YEAR ( [Date] ) - 1, 2 )
     VAR FinYear =
         IF ( MONTH ( [Date] ) &gt; 3, CY &amp; "-" &amp; NY, PY &amp; "-" &amp; CY )
     RETURN
         FinYear,
     "FinWeekNo", WEEKNUM ( EDATE ( [Date], -3 ), 2 ),
     "CalWeekNo", WEEKNUM ( [Date], 2 ),
     "Weekend/Working", IF ( WEEKDAY ( [Date], 2 ) &gt; 5, "Weekend", "Working" ),
     "Day", FORMAT ( [Date], "ddd" ),
     "CustomDate", FORMAT ( [Date], "d/mm" )
  )
  </code></pre>
  
  <p>now how i modified above code</p>