Find start date of week and repeat the date

[Rygar]

Dear Community,

i have a Column with ascending dates and need the starting date of each week in a second column:

I need this in Power Query. Example File here.

Thanks and regards, Michael

[AntrikshSharma]

@Rygar Use this:

let
    Source = Table.FromRows (
        Json.Document (
            Binary.Decompress (
                Binary.FromText (
                    "Vc67DcAwDAPRXVwHkER/Ys1ieP81DBdByPJVd2uVaUiDA2U/V9VF8StNAEZlNEZnDMbLmIyUqIt0SCZCLuLb2Ac=",
                    BinaryEncoding.Base64
                ),
                Compression.Deflate
            )
        ),
        let
            _t = ( ( type nullable text ) meta [ Serialized.Text = true ] )
        in
            type table [ #"From this" = _t ]
    ),
    ChangedType = Table.TransformColumnTypes ( Source, { { "From this", type date } } ),
    WeekOfYear = 
        Table.AddColumn (
            ChangedType,
            "Week of Year",
            each Date.WeekOfYear ( [From this], Day.Monday ),
            Int64.Type
        ),
    GroupedRows = 
        Table.Group (
            WeekOfYear,
            { "Week of Year" },
            {
                {
                    "Transformation",
                    ( Dates ) =>
                        Table.AddColumn (
                            Table.RemoveColumns ( Dates, "Week of Year" ),
                            "To this",
                            each List.Min ( Dates[From this] ),
                            type date
                        )
                }
            }
        ),
    RemovedOtherColumns = Table.Combine ( GroupedRows[Transformation] )
in
    RemovedOtherColumns

[Rygar]

Thanks a lot 4 your support!

[m_alireza · Accepted solution]

Hi @Rygar ,

Create a Custom Column in Power Query and enter this: 

=Date.StartOfWeek([From this], Day.Monday)

where [From this] equals name of your date column

[Rygar]

Great! Thanks a lot.