cancel
Showing results for
Did you mean:
New Member

## Dax Same Period (user defined) Period Last Months

Hi everyone,

I need help to get the average of sales of past 3 months relative to the user defined day of the month (selectedvalue).

I am able to find similar solution but this always points to date TODAY().

For example, today is April 16, 2021:

- I would like to select April 20, 2021 (future date);

- Average of the following dates would be shown:

March 1 - 20

Feb 1 - 20

Jan 1 -20

This is the similar solution i found and tried to edit by replacing TODAY() with SELECTEDVALUE:

=====

2-MonthSamePeriod Sum =
CALCULATE (
SUM ( 'Sheet 1'[Order Lines/Subtotal w/o Tax] ),
FILTER (
'DATE',
AND (
[Date]
>= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 1, 1 ),
[Date]
<= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 1, DAY ( TODAY () ) - 1 )
)
)
)

Jap

1 ACCEPTED SOLUTION
Community Support

Hi @jao_ortiz ,

Please use the following measure to get the average of sales of past 3 months:

``````Measure =
AVERAGEX (
FILTER (
'Date',
DATESINPERIOD ( 'Date'[Date], MAX ( 'Date'[Date] ), -3, MONTH )
),
SUM ( 'Sheet 1'[Order Lines/Subtotal w/o Tax] )
)``````

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

3 REPLIES 3
Community Support

Hi @jao_ortiz ,

Please use the following measure to get the average of sales of past 3 months:

``````Measure =
AVERAGEX (
FILTER (
'Date',
DATESINPERIOD ( 'Date'[Date], MAX ( 'Date'[Date] ), -3, MONTH )
),
SUM ( 'Sheet 1'[Order Lines/Subtotal w/o Tax] )
)``````

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

Responsive Resident

@jao_ortiz Hey

Try this

Super User IV

@jao_ortiz , Try a measure with help from date Table

Rolling 3 =
var _max = day(MAXX(ALLSELECTED('date'),'date'[Date])) //or // day(Today()) //or// Day(today()+4)
return
CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH), filter('Date', Day('Date'[Date]) <=_max))

//or are replacement values that you can use for _max

Proud to be a Super User!

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.