how to calculate each Monday amount from date ?

[HannanGohar]

Hi Daxing

i have two months date, i got day from date. i want to calculate amount each monday from my date. (sum of all mondays.) 

any suggestion. 

[Chihiro · Accepted solution]

Something like below would work. Even without [Day] column.

TotalMonday =
CALCULATE (
    SUM ( Table[ValueColumn] ),
    FILTER ( Table, WEEKDAY ( [DateColumn], 2 ) = 1 )
)