12 Month rolling new table calculate

[fabiopaturzo]

Hi All,

I dowload these date diretly from Business Central,

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

[amitchandak]

@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

[fabiopaturzo]

Hi Amiychandak

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

Table name is Sales