cancel
Showing results for
Did you mean:  Post Partisan

## DATESINPERIOD 6 months back starting from last month

I need to calculate a measure with an interval of:

Current month -7  to last month.

The measure for the last 6 months is the following, but I need to do it from Current month -7 to current month -1

``````Avrg 6M =
CALCULATE(
[Measure] ;
DATESINPERIOD(
Calendar[Date];
LASTDATE(Calendar[Date]);
-6;
MONTH
)
)``````

1 ACCEPTED SOLUTION  Solution Sage

Hello @setis,

Please try the following DAX formula:

``````Avrg 6M =
CALCULATE(
[Measure],
DATESINPERIOD(
Calendar[Date],
EOMONTH(TODAY(),-1),
-6,
MONTH
)
)``````

Hope this helps.

3 REPLIES 3  Solution Sage

Hello @setis,

Please try the following DAX formula:

``````Avrg 6M =
CALCULATE(
[Measure],
DATESINPERIOD(
Calendar[Date],
EOMONTH(TODAY(),-1),
-6,
MONTH
)
)``````

Hope this helps.  Post Partisan

It does. Thank you very much!  Solution Sage

@setis, if this solution helped, please mark it as 'Accepted' so that it helps others.

Thanks 🙂   