How to find the last weekday of a month

[ThomasWeppler]

Hi Power BI community
I a table with x columns 

1. [Index]: An Index column

2. [Specifications]: A column (could be FirstMonday, SecondWednesday or LastFriday)

3. [Date]: A date

I want a column that shows true if the [Specifications] is "LastFriday" and [Date] is the last friday in the month. and otherwise show false
Is this even possible?

Any help will be greatly appreciated.

[ThomasWeppler]

Thanks @slorin 
It works perfectly.

[slorin · Accepted solution]

Hi

Add new column

[Specifications]="LastFriday" and Date.Month(Date.AddDays([Date],7))<>Date.Month([Date]) and Date.DayOfWeek([Date])=4

Stéphane