DAX Measure for differentiating between two timeframes

[bonjourposte]

We have one table (LOANHIST) that we use to "create" two different timeframes.  We're always comparing this month to last month.  If the status of the loan changed between the two months (and a bunch of other filters are applied), then we know that that loan was a renewal or an extension.

In the table, there is Accounting Date, Maturity Date, Current Amortization Months, and Loan Term.  We need to use those columns twice- once for the Current time frame, and once for the previous month's time frame.  ("Accounting Date" drives the measure, and it is always the last day of every month.)

This is what our columns look like: 

This is the code my boss used to extract the info from SQL.  How do I translate this into DAX?  I have no idea where to begin.  Am I creating virtual tables?  Am I creating two variables for every column that we need?

Am I using DATEADD or PARALLELPERIOD?  

[Ashish_Mathur]

Hi,

Share some data to work with, explain the question and show the expected result.  Share data in a format that can be pasted in an MS Excel file.