Get next 12 months since the filter date

[BIEvotic]

Hi, I have a filter to select a date

And I need to show the values of the next 12 months (separated, not a calculation!). What function I need for that?

[amitchandak]

@BIEvotic , if you want 12 months rolled into one month then you can try like

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

If you want to display 12 month, you need an independent date table

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI