cancel
Showing results for
Did you mean:
Frequent Visitor

## 12 Month rolling new table calculate

Hi All,

and I needd for Item Number calucate in a new Table or new column he 12 month rolling updated every day or week

 Item_No Somma di Sold_Quantity Year Quarterly Month DAY TANK1 2000 2022 Trim 4 November 18 TANK 3 2500 2022 Trim 4 December 1 TANK 3 3000 2022 Trim 1 February 28 TANK2 200 2022 Trim 3 August 8 TANK2 8000 2022 Trim 2 June 27 TANK2 5000 2022 Trim 4 November 18 TANK 3 6000 2022 Trim 4 October 25 TANK1 3000 2022 Trim 4 November 3 TANK1 40000 2022 Trim 2 April 20 TANK 3 23420 2022 Trim 1 February 28 TANK1 21400 2022 Trim 1 February 18 TANK 3 20000 2022 Trim 3 settembre 8
2 REPLIES 2
Super User

@fabiopaturzo , You can create a new measure

example

Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-12,MONTH))

Rolling Months Formula: https://youtu.be/GS5O4G81fww

Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc

!! Microsoft Fabric !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Frequent Visitor

Hi Amiychandak

Can you please apply the formula on the follow table/ colomns name, I have some some errors?

Table name is Sales