Calendar for future dates

[shyamji]

Hi,

i need to display devices count graph for future dates.Suppose i select january 2020 from slicer then need to display graph from feb to july. The code for last 6 months working 

Last6MonthsData =

CALCULATE (

SUM(WarrantyExpiryDevicesQuarterly_Updated[Devices]),

DATESINPERIOD ('Date'[Date], MAX('Date'[Date]), -6, MONTH )

)

in the same way i need DAX query for incoming 6 months.

Thanks

Shyamji

[v-juanli-msft]

Hi @shyamji 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?

If not, please feel free to let me know.

Best Regards

Maggie

[v-juanli-msft · Accepted solution]

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.