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 🙂

Announcements

#### Launching new user group features

Learn how to create your own user groups today!