Weekly Data

Hi Anonymous 

Yes, it is possible.

As amitchandak suggested, "relative filter" should work.

If the "date/time" column is a text column instead of a date-time column, please make some transformation in Edit queries.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("jdI5DoMwEAXQq4xcu5ix2ZwuB0ApSIcoCBohJEhQ5PsrS+ep/gFe98bRDXpmPR76phA8BZZEc6Z0YaZr77wb5uPclXrVvD1Xum95V3GTL2REZbCyQmW0skZlZWWDytrKFpWNlR0qWysTKjsjI6My/eVtya+fE7gBFw7vI4WD80goHFxHvnemDw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"date/time" = _t, meeting = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"date/time", type text}, {"meeting", type text}}),
    #"Duplicated Column" = Table.DuplicateColumn(#"Changed Type", "date/time", "date/time - Copy"),
    #"Replaced Value" = Table.ReplaceValue(#"Duplicated Column","at","-",Replacer.ReplaceText,{"date/time - Copy"}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Replaced Value", "date/time - Copy", Splitter.SplitTextByDelimiter("-", QuoteStyle.Csv), {"date/time - Copy.1", "date/time - Copy.2"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"date/time - Copy.1", type date}, {"date/time - Copy.2", type time}})
in
    #"Changed Type1"