Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.