DAX to show previous month's value

[ukrutter]

Can someone please help with showing me how to write a DAX formula to show the previous month's value? The current column formulae I have are as follows:

Incident YearMonth = FORMAT(GoAheadClaim[Incident_Date of Incident],"yyyy mm")

Average of total claims = calculate(averagex(GoAheadTPA,GoAheadTPA[Claims Paid]+GoAheadTPA[Claims Reserve]))

Total Claims Prev Mth = 

calculate(averagex(GoAheadTPA,GoAheadTPA[Claims Paid]+GoAheadTPA[Claims Reserve]),OFFSET(-1,ALLSELECTED(GoAheadClaim[Incident YearMonth])))

[Kaviraj11 · Accepted solution]

Try this out:

Total Claims Prev Mth =
CALCULATE(
AVERAGEX(
GoAheadTPA,
GoAheadTPA[Claims Paid] + GoAheadTPA[Claims Reserve]
),
DATEADD(GoAheadClaim[Incident YearMonth], -1, MONTH)
)