topic Area Chart add 2 filters to a measure to show specific period in DAX Commands and Tips

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

Anonymous — Tue, 16 Aug 2022 08:52:08 GMT

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

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

v-xiaotang — Fri, 19 Aug 2022 02:13:52 GMT

Hi Anonymous

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.