Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
Hi @shyamji
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.