sum week end value at monday

Hi filippoalicicco,

You can consider to use if statement with weekday function to get current date, then use it to filter and summary record.

Summary on Monday =
VAR currDate =
    MAX ( Table[Date] )
RETURN
    IF (
        WEEKDAY ( currDate, 2 ) = 1,
        CALCULATE (
            SUM ( Table[Amount] ),
            FILTER (
                ALLSELECTED ( Table ),
                YEAR ( Table[Date] ) = YEAR ( currdate )
                    && WEEKNUM ( Table[Date] ) = WEEKNUM ( currDate, 1 )
            )
        ),
        SUM ( Table[Amount] )
    )

Regards,

Xiaoxin Sheng