title: Power BI DAX to get previous month value from custom date
body: <p>I have a data which is having FiscalDate information (Fiscalyear starts from July). Currently there is a column which shows Revenue, but the Revenue is Fiscal Year to date. The requirement is to get Current month and previous month revenue. Since its a custom date, I cannot use the standard date function to get previous month value. Could anyone please suggest Dax which can provide me the previous month Revenue. It should work even if extra filters are added to the report.
  Given data set
  <a href="https://i.stack.imgur.com/b13bt.png" rel="nofollow noreferrer">enter image description here</a></p>
  
  <p>expected output</p>
  
  <p><a href="https://i.stack.imgur.com/oHfxr.png" rel="nofollow noreferrer">enter image description here</a></p>