How to do WTD.

[aamaninanneboin]

Hi All, 

I am trying to do WTD calculation and unable to fix it out. I am able to do with auto generated calendar but not with the normal expression. Can any one please help me out with the expression. 

Thanks,

Aamani 

[Vegar · Accepted solution]

Try
Sum({<Date={">=$(=Num(WeekStart( Max(Date) ) ) ) <=$(=Max(Date))"}>}[Amount])