Logical AND OR not working as expected

Hi Anonymous ,

Are you using measures to create your table? asking this becasue the notation looks like the use of measures especially on the [Weekday(Wed-Tue)] .

Can you also refer what is the last date of your calendar.

Also I do not understand the logic of [Weekday(Wed-Tue)] = 7 or Current date and today -1.

What is the final result you want to achieve is the to what I can read you want the last days of every week meaning that you want to filter out your table with all the Sundays and from last sunday until yesterday?

One question that I saw is that you have Calendar[Date] = Today-1 since all the days from the calendar are lower than 7 for this week you will not get results since the first day of the week is 7 try the following:

SubTable calendar end of week =
VAR _currentWeek =
    MAX ( 'calendar'[Week of Year(Wed-Tue)] )
RETURN
    CALCULATETABLE (
        'Calendar',
        FILTER (
            'calendar',
            OR (
                [Weekday(Wed-Tue)] = 7,
                AND (
                    [Week of Year(Wed-Tue)] = _currentWeek,
                    [calendar_date].[Date]
                        <= TODAY () - 1
                )
            )
        )
    )