This article offers formulas to simulate STARTOFWEEK and ENDOFWEEK functions like Date.StartOfWeek and Date.EndOfWeek functions of Power Query language M
This article provides formulas for Text.ContainsAny and Text.ContainsAll functions as these are not provided by Power Query Language M.