Calculating a increase in faults across multiple Days/Dates

Hi Anonymous,

Sorry for the delay, I was working on a deadline project in the last few weeks.

I think you get the idea right. "Closing" column is the "closing balance" (number of faults) for the day as you have it as runing total. It eaquals to the number of faults on the next day. Of course your rows should be sorted by the Date column.

You can apply if to the mixed unique items in the same table by using Table.Group.

This example a bit messy, but it gives you an idea where to go:

let 
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjTWMzDUMzIwMlbSUXIrykxJrAQyTAwMgKR/UWJeeqpSrA5QmQmSsuDEktIiiEJLDIVYzTMFqXIsKMjBb5qRAZK6WAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t, Days = _t, #"Number of faults" = _t, Fruit = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Days", type text}, {"Number of faults", Int64.Type}}),
vt = Value.Type(Table.AddColumn(#"Changed Type", "Closing", each null, type number )),
#"Grouped Rows" = Table.Group(#"Changed Type", {"Fruit"}, {{"Data", each 
    let 
            Combine = Table.ToColumns(_) & {List.Skip(_[Number of faults])},
            Format = Table.FromColumns(Combine, vt)
        in Format
    }}),
    #"Expanded Data" = Table.ExpandTableColumn(#"Grouped Rows", "Data", {"Date", "Days", "Number of faults", "Closing"}, {"Date", "Days", "Number of faults", "Closing"}),
    #"Reordered Columns" = Table.ReorderColumns(#"Expanded Data",{"Date", "Days", "Number of faults", "Fruit", "Closing"}),
    Custom1 = #table(vt, Table.ToRows(#"Reordered Columns")),
    #"Added Custom" = Table.AddColumn(Custom1, "Increase", each [Closing]-[Number of faults])
in
    #"Added Custom"