=
VAR thisDate = 'events'[дата]
VAR dateFilter =
    FILTER(
        'events';
        'events'[дата] <= thisDate
            && ( 'events'[событие 1] <> 0
            || 'events'[событие 2] <> 0 )
    )
VAR beforeOrThisEventDate =
    CALCULATE( MAX( 'events'[дата] ); dateFilter )
RETURN
    thisDate - beforeOrThisEventDate

let
    dataBody = Excel.CurrentWorkbook(){[Name="dataBody"]}[Content],
    typedDataBody = Table.TransformColumnTypes(dataBody, {{"SKU", type text}, {"EAN-Code", type text}, {"Category", type text}, {"description", type text}, {"Make", type text}, {"Model", type text}, {"Year", type text}, {"EUR", Currency.Type}}),
    defineMakeModels = Table.AddColumn(typedDataBody, "temp", each
        [
            makers = List.Transform(Text.Split([Make], "/"), each Text.Lower(Text.Trim(_))),
            models = List.Transform(Text.Split([Model], ","), each Text.Lower(Text.Trim(_))),
            toTable = Table.Join(Table.FromColumns({makers}, {"makeKey"}), {}, Table.FromColumns({models}, {"modelKey"}), {})
        ][toTable]
    ),
    expandDataBody = Table.ExpandTableColumn(defineMakeModels, "temp", {"makeKey", "modelKey"}),
    makeModels = Excel.CurrentWorkbook(){[Name="makeModels"]}[Content],
    typedMakeModels = Table.TransformColumnTypes(makeModels,{{"производитель", type text}, {"модель", type text}}),
    addMakeKey = Table.AddColumn(typedMakeModels, "makeKey", each Text.Lower(Text.Trim([производитель]))),
    addModelKey = Table.AddColumn(addMakeKey, "modelKey", each Text.Lower(Text.Trim([модель]))),
    result = Table.Join(expandDataBody, {"makeKey", "modelKey"}, addModelKey, {"makeKey", "modelKey"}, JoinKind.Inner),
    #"Removed Columns" = Table.RemoveColumns(result,{"makeKey", "modelKey"})
in
    #"Removed Columns"