Area Chart add 2 filters to a measure to show specific period

[mohamedsabbah]

Hi 
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]))))

[v-xiaotang]

Hi @mohamedsabbah 

Thanks for reaching out to us.

>> I want to add another one to retrieve only the last 10 months.

If you try this, will it work?

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.