Fortnight Flag (every 14 days) with DAX?

[Rewind]

I have a dim_date table and I'd like to be able to flag every second Wednesday beginning at a specific date.

Is this possible with DAX? I found a few examples flagging all the dates within a period but I only really need the specific day.

Thanks

[amitchandak · Accepted solution]

@Rewind , First find the first Wednesday or choose a hard coded date

Try like

a new column =

var _first = minx(filter(Date,  weekday([Date],2)=3) , [Date])

var _diff = Mod(Quotient(datediff(_first , [Date], day),7),2)

return

if(_diff =0, true(), false())

[Rewind]

Thank you - works perfectly.