Forum Discussion
Weekly Data
Hi Guys, I'm trying to create a visualization that lists the latest weekly meetings that I need to attend to. It would automatically update the current date and time and meeting title for next week...
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"Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks! But would it be possible to show the current meetings for the week?
Sunday to Saturday.
Thank you!
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"
Best Regards
Maggie
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.