The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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:
Solved! Go to Solution.
Try this out:
Total Claims Prev Mth =
CALCULATE(
AVERAGEX(
GoAheadTPA,
GoAheadTPA[Claims Paid] + GoAheadTPA[Claims Reserve]
),
DATEADD(GoAheadClaim[Incident YearMonth], -1, MONTH)
)
Proud to be a Super User! | |
Try this out:
Total Claims Prev Mth =
CALCULATE(
AVERAGEX(
GoAheadTPA,
GoAheadTPA[Claims Paid] + GoAheadTPA[Claims Reserve]
),
DATEADD(GoAheadClaim[Incident YearMonth], -1, MONTH)
)
Proud to be a Super User! | |
User | Count |
---|---|
16 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
13 | |
13 | |
8 | |
8 |