Amend DAX measure to give end of last month as opposed to start of current month

[Anonymous]

Hi Experts

How would you change the following DAX to give you end of last month - as opposed to start of current month..... see hightlight VAR

Rolling 12 till last month FEP =

VAR EndDatelastMonth = MAX('Calendar'[Date])

VAR StartDate = DATE(YEAR(EndDatelastMonth) - 1,MONTH(EndDatelastMonth),-1)

VAR Result = CALCULATE( [MONTHLY TOTAL (FEP)],

    REMOVEFILTERS('Calendar'),

    DATESBETWEEN( 'Calendar'[Date], StartDate, EndDatelastMonth ))

RETURN

Result

[amitchandak · Accepted solution]

@Anonymous , Last month end date id

eomonth(today() ,-1)

eomonth(maxx(allselected('Date'),'Date'[Date])  ,-1)

what do you want to get there?

[Anonymous]

Hi Amit - I want to update my measure to give last 12 months excluding current month based on calender table....

STUCK