Calendar for future dates

Hi shyamji 

If you original table has data for 2020/2-2020-6, the following measure should work.

 

next6MonthsData = 
CALCULATE (
SUM(WarrantyExpiryDevicesQuarterly_Updated[Devices]),
DATESINPERIOD ('Date'[Date], MAX('Date'[Date]), 6, MONTH )
)

 

If you don't have any data for next 6 months, please tell me the rule to complete this.

For example, i have data for 2019/1~2020/3, then i select 2020/1 from the slicer, want to see the next 6 months' data,

I define the rule is: get the average of the data of 2020/2, 2020/3, then use the average for 2020/4,2020/5,2020/6,2020/7,

the measure is as follows:

average = CALCULATE(AVERAGE('Table'[value]),DATESINPERIOD('date'[Date],MAX('date'[Date]),5,MONTH))

next 6 months = 6*[average]

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.