Calculate measure value same day of few last weeks

[mh2587]

Hi

I hope you all doing well

I have scenario in we have to calculte the of same day and last week same day ( the case will be multiple same days)

E.g let suppose today is Monday and Previouse same day will be Monday and so on 

on Same days filter I am calculating measure values
14-03-2022 = Monday

07-03-2022 = Monday

28-02-2022 = Monday and So on

Thanks Advance for helping

[v-yanjiang-msft]

Hi @mh2587 ,

Has your problem been solved? If yes, please consider accept it as the solutionto help the other members find it more quickly. 

If not, do you want to get dates of the same weekday within few last weeks, or anything else. Can you give an example?

Best Regards,
Community Support Team _ kalyj

[mh2587 · Accepted solution]

I have still the issue but I am going to close this thread 

[rsbin]

@mh2587,

If I understand your question correctly, I perform this same measure.

Please review the code below.  You can modify per your exact requirements.

When I was first doing this, the key was identifying and using the Weekday function.

LiftWorkOrders_SameDay_4WkAvg = 
VAR _LastDate = TODAY() - 1
VAR _Weekday = WEEKDAY( _LastDate )
VAR _Duration = 3           // Prior 3 Weekdays + LastDate gives 4 Periods
VAR _FirstDate = _LastDate - _Duration*7
VAR _CalculationPeriod = // Isolate the 4 Prior Weekdays
                                FILTER( ALL ( DIM_Date ),
                                  AND( AND (DIM_Date[Date] >= _FirstDate,
                                       DIM_Date[Date] <= _LastDate ),
                                       WEEKDAY(DIM_Date[Date]) = _Weekday ))

VAR _MovingAverage = CALCULATE (AVERAGEX( DIM_Date,[LiftWorkOrders]), _CalculationPeriod )

RETURN
       _MovingAverage

 Hope this works for you.

Good Luck and Regards,