Share
ReportHi
I'm trying to show only the last 10 months in the area chart, Measure already filtered as shown below I want to add another one to retrieve only the last 10 months.
EVC Cumm. =
var lastdateevc = CALCULATE(LASTDATE(EVCDis[DatesID]),EVCDis[DisUnit]>0)
var m10 = edate(lastdateevc,-10)
return
IF(max(DatesID[DatesID])<lastdateevc ,BLANK(),
CALCULATE(
SUM(EVCDis[DisUnit]),
FILTER(
ALLSELECTED(DatesID[DatesID]),
DatesID[DatesID]<= MAX(DatesID[DatesID]))))
Categories:
I have the same question (0)
All responses (
Answers (
1,070
