Forum Discussion
Annualised 12 Month Sum Rolling
Hi PowerBi'ers!!
Nearly Chrismas 🙂
I have one for you all, which im sure is simple, but I've been trying different solutions ive seen on here and youtube, but it doesnt calculate right.
Scenario: x1 calculation column IW-MFR basically sums "IW-Faulty" and divides by "Cumulative Shipment" for each row
Aim: Create another column with a sum for rolling 12 months (sum the current row and the previous 11 rows) - This can be in Powrquery or a DAX column.
I have this in excel which is simple and is literally Sum previous current and previous 11 months:
This would make my Christmas if this could be solved!!! 🙂
Cheers Guys!!
9 Replies
- Mahesh0016
Super User
SUM 12month =
VAR Total =
CALCULATE (
[Total ListPrice],
DATESINPERIOD ( 'Date'[Date], [LastCurrentDate], -12, MONTH )
)
RETURN
Total
******************************************************LastCurrentDate = MAX('Date'[Date])******************************************************Total ListPrice = SUM(TrainingSample2[ListPrice])- Mahesh0016
Hi Anonymous ,
You can not use in M Code it is use only Power bi desktop DAX Measure.
