Measure for LTM excluding "selected month"

[PeterStuhr]

Hello,

I need to do a LTM / TTM measure.

My problem is, that I don't want to include the month selected, but the 12 months prior.

Example: 

For

Dec 2021 = Dec2020-Nov2021

Nov 2021 = Nov 2020-Oct2021

The measure I did now, includes the "selected month". How do I modify it to always "push back 1 month"?:

LTM = Calculate (

Selectedmeasure (),

DATESINPERIOD ( 'Calendar'[Calendar Date],

MAX( 'Calendar'[Calendar Date] ),

-12,

MONTH)

[amitchandak · Accepted solution]

@PeterStuhr , Try like

LTM = Calculate (

Selectedmeasure (),

DATESINPERIOD ( 'Calendar'[Calendar Date],

eomonth(MAX( 'Calendar'[Calendar Date] ),-1) ,

-12,

MONTH)