Weekly Data

[swaggerboy69]

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.

For example:

Date:

Date / Time: Meeting Title

September 22, 2019 at 9:00 AM	Sample Meeting Title
September 23, 2019 at 9:00 AM	Sample Meeting Title
September 24, 2019 at 9:00 AM	Sample Meeting Title
September 25, 2019 at 9:00 AM	Sample Meeting Title
September 26, 2019 at 9:00 AM	Sample Meeting Title
September 27, 2019 at 9:00 AM	Sample Meeting Title
September 28, 2019 at 9:00 AM	Sample Meeting Title

I hope you guys can help me out.

[v-juanli-msft]

Hi @swaggerboy69 

Today is 2019/9/26, you want the visual to show meeting of the current week (2019/9/22~2019/9/9/28), 

or meeting from today to next 7 days (2019/9/26~2019/10/2)?

Best Regards
Maggie

[swaggerboy69]

Hello!

I would like it to show the weekly meetings.

So it should be (2019/9/22~2019/9/28).

Thank you! 

[amitchandak]

are you looking for relative date filtering. You can get that on filter pane. Last one week or Next one week options are available 

[swaggerboy69]

Thanks! But would it be possible to show the current meetings for the week?

Sunday to Saturday.

Thank you!

[v-juanli-msft · Accepted solution]

Hi @swaggerboy69 

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

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.

[amitchandak]

There is a this week option. Is that not working for you