title: Add previous month column DAX Power BI
body: <p>I have a fact table which has <code>'Last Data Update'</code> column that shows current month date(mm/dd/yyyy), 06/13/2022.</p>
  <p>I am trying to add column called <code>'report month'</code> that returns a value that shows previous month/year 05/2022 to create relationship with calendar table.</p>
  <p><code>=Date.Month([Last Data Update])-1</code></p>
  <p>I have used this code, but this only returns <code>5</code> and it is in number format.</p>
  <p>is there a way to return <code>05/2022</code> in DAX ?</p>
  <p>Thanks in advance.</p>