Monday that comes after last friday of the previous month

[bml123]

HI,

I want to get monday that comes after last friday of the previous month in the calendar table.  How do I get that?

[v-angzheng-msft · Accepted solution]

Hi, @bml123 

Try this:

Result =
CALCULATE(
    MAX( 'Table'[Date] ),
    FILTER(
        ALL( 'Table' ),
        'Table'[Date] <= EOMONTH( MAX( 'Table'[Date] ), -1 )
            && 'Table'[Date] > EOMONTH( MAX( 'Table'[Date] ), -2 )
            && WEEKDAY( [Date], 2 ) = 5
    )
) + 3

Result:

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

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

[serpiva64]

Hi,

i think you are not sorting correctly. As text monday cames after friday. You need to sort Day Name for Numeric values of Day in Week.

[bml123]

Hi @serpiva64 

It's not about sorting.  For every date in the calendar table, I need to add a column to get monday that comes after last friday of the previous month in the calendar table.  How do I achieve that?