weeks ago Saturday DAX

Categories

calculated column in dates table

= COUNTROWS(FILTER(Dates,([DateEN]<=TODAY() )&&( [DateEN] >= EARLIER(Dates[DateEN] )) &&( Dates[DayOfWeek]=7))