Trailing 4 Week calculation help

[Anonymous]

Hey everyone, 

I'm stuck on a calucation I need some help with. 

I have the following date table 

 and I have average customer satisfaction score by date in another table 

I'm trying to look at trailing week, 

Trailing week ending = 'Date'[Date]+(0-'Date'[weekdaynumber])

which seems to be working  corrently

and trailing 4 week 

so last weeks numbers + 3 weeks before that

I tried the following but it's not working

Trailing 4 week csat =

calculate([Csat %],

DATESINPERIOD ('Date'[Trailing week ending].[Date],LASTDATE ( 'Date'[Trailing week ending].[Date]),-28,DAY))

this doesn't seem to give the correct amount however. 

anyone have

[Anonymous]

Hi @Anonymous,

Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[DataInsights]

@Anonymous,

The post below may be helpful:

https://community.powerbi.com/t5/Desktop/Date-Grouping-based-on-MOST-RECENT-dates/m-p/1461638#M610942