How to find out if a Monday is the last Monday for the month?

[aiyosap]

Dear Power BI guru,

I am wondering if there is a way todetermine which one in a list of Monday's dates is the last Monday for the month.

For example, the following list of date are all Monday, and I want to know which one of them is belong to the last Monday for the month.

I cannot find any query function to achieve this, could you help? thank you.

Regards,

Aiyo

[v-kkf-msft · Accepted solution]

Hi @aiyosap ,

Please try the measure.

Is_last_Monday = 
VAR diff =
    DATEDIFF ( MAX ( 'Table'[Date] ), EOMONTH ( MAX ( 'Table'[Date] ), 0 ), DAY )
RETURN
    IF ( diff <= 6 && diff >= 0, 1 )

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@aiyosap , for any date last Monday is

'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1

using Today

Today()+-1*WEEKDAY(Today(),2)+1

[aiyosap]

I notice, many times, you have simply provide answer for the sake of gaining the top kudo spot in the forum.

This is not right. please stop. 

Thank You.