Are you looking to do it with a calculate column or a measure?
Assuming your table is named Revenues
You can do it via a calculated column like this:
=<br><span class="Keyword" style="color:#0070FF">CALCULATE</span><span class="Parenthesis" style="color:#969696"> (</span><br><span class="indent4"> </span><span class="Keyword" style="color:#0070FF">SUM</span><span class="Parenthesis" style="color:#969696"> (</span> Revenues[Revenue] <span class="Parenthesis" style="color:#969696">)</span>,<br><span class="indent4"> </span><span class="Keyword" style="color:#0070FF">ALLEXCEPT</span><span class="Parenthesis" style="color:#969696"> (</span><br> Revenues,<br> Revenues[Account ID]<br><span class="indent4"> </span><span class="Parenthesis" style="color:#969696">)</span>,<br> Revenues[Sales Year] = <span class="Keyword" style="color:#0070FF">EARLIER</span><span class="Parenthesis" style="color:#969696"> (</span> Revenues[Sales Year] <span class="Parenthesis" style="color:#969696">)</span> - <span class="Number" style="color:#EE7F18">1</span><br><span class="Parenthesis" style="color:#969696">)</span><br>
Via a measure, one solution can be:
=<br><span class="Keyword" style="color:#0070FF">CALCULATE</span><span class="Parenthesis" style="color:#969696"> (</span><br><span class="indent4"> </span><span class="Keyword" style="color:#0070FF">SUM</span><span class="Parenthesis" style="color:#969696"> (</span> Revenues[Revenue] <span class="Parenthesis" style="color:#969696">)</span>,<br><span class="indent4"> </span><span class="Keyword" style="color:#0070FF">FILTER</span><span class="Parenthesis" style="color:#969696"> (</span><br><span class="indent8"> </span><span class="Keyword" style="color:#0070FF">CALCULATETABLE</span><span class="Parenthesis" style="color:#969696"> (</span><br> Revenues,<br><span class="indent8"> </span><span class="indent4"> </span><span class="Keyword" style="color:#0070FF">ALL</span><span class="Parenthesis" style="color:#969696"> (</span> Revenues[Sales Year] <span class="Parenthesis" style="color:#969696">)</span><br><span class="indent8"> </span><span class="Parenthesis" style="color:#969696">)</span>,<br> Revenues[Sales Year] = <span class="Keyword" style="color:#0070FF">MAX</span><span class="Parenthesis" style="color:#969696"> (</span> Revenues[Sales Year] <span class="Parenthesis" style="color:#969696">)</span> - <span class="Number" style="color:#EE7F18">1</span><br><span class="indent4"> </span><span class="Parenthesis" style="color:#969696">)</span><br><span class="Parenthesis" style="color:#969696">)</span><br>
the DAX may vary depending on how you want the calculation to behave at the total level