Max date in selected week

Hi mykolasg ,

I think you want to calculate the date of max balance in select week. You can try this code.

Max Date select week =
VAR _SELECT_WEEK =
    SELECTEDVALUE ( 'Dim Week Number'[Week Number] )
VAR _MAX_Balance =
    CALCULATE (
        MAX ( 'Table'[Balance] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Week Number] = _SELECT_WEEK )
    )
VAR _MAX_Date =
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Week Number] = _SELECT_WEEK
                && 'Table'[Balance] = _MAX_Balance
        )
    )
RETURN
    _MAX_Date

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.