Calculation of data for the next 6 months based on the most recent month's data

[soldier_rong]

Dear~

I have the following data, red is historical data, green is current data (calculated using PREVIOUSMONTH), how do I calculate 202301, 202302, 202303, 202304 after yellow?

I have the date dimension table, as in the date on the left.

Although I use PREVIOUSMONTH again, 202302 comes out with empty data...but not workd.

Thanks in advance

BR

Soldier

[amitchandak]

@soldier_rong , Next 6 month exculding current

next Rolling 6 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],eomonth(MAX('Date'[Date]),0)+1,-6,MONTH))

next 6 months including the current

next Rolling 6 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],eomonth(Min('Date'[Date]),-1)+1,-6,MONTH))

[soldier_rong]

Hi @amitchandak ,

Cool,  however, the data on 202212 should be taken from 202211 and I drafted a sample data as the below. 

This is an iteration that relies on the previous month's data (it started out as 202212 relying on 202211)

Thanks again.

BR,

Soldier