Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

12 Month rolling new table calculate

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_NoSomma di Sold_QuantityYearQuarterlyMonthDAY
TANK120002022Trim 4November18
TANK 325002022Trim 4December1
TANK 330002022Trim 1February28
TANK22002022Trim 3August8
TANK280002022Trim 2June27
TANK250002022Trim 4November18
TANK 360002022Trim 4October25
TANK130002022Trim 4November3
TANK1400002022Trim 2April20
TANK 3234202022Trim 1February28
TANK1214002022Trim 1February18
TANK 3200002022Trim 3settembre8
Super User
Super User

@fabiopaturzo , You can create a new measure



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



Rolling Months Formula:


Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD:

!! 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! !!

Hi Amiychandak

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

Table name is Sales






Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors