Power Platform Community Forum Thread Details

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

Categories:

Power Query

Community site session details

Filter specific period for Area Chart with DAX

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates