Previous week's value to next week RRS feed

  • Question

  • Hi,

    My purpose is to fill the weeks having no data with the data of previous week and roll it up across the weeks till there is data for the week in a matrix visual.So can anyone help me in it?


    Friday, December 22, 2017 3:36 PM


  • You can use fill down:

        Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTI0UIrViVYyAjLBDGMgwwgiZgITMwUzYgE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Week = _t, Data = _t]),
        #"Changed Type" = Table.TransformColumnTypes(Source,{{"Week", Int64.Type}, {"Data", Int64.Type}}),
        #"Filled Down" = Table.FillDown(#"Changed Type",{"Data"})
        #"Filled Down"

    Friday, December 22, 2017 3:51 PM