date_with_fact =
VAR update_date =
    MAX ( 'Дата'[Дата обновления] )
VAR result = 'Calendar'[Date] <= update_date
RETURN
    result

_Выручка:=SUM ( 'Выручка'[Сумма] )

_Прошл период:=
CALCULATE (
    [_Выручка];
    CALCULATETABLE (
        DATEADD ( 'Calendar'[Date]; -1; YEAR );
        'Calendar'[date_with_fact]
    )
)

= B4/(СУММПРОИЗВ($B$4:$B$18;$D$4:$D$18)/СУММПРОИЗВ($B$4:$B$18;$D$4:$D$18;1/(1+$C$4:$C$18)))

MEASURE =
SUMX (
    data,
    VAR dates =
        FILTER (
            'Calendar',
            'Calendar'[Date] >= data[Start Date]
                && 'Calendar'[Date] <= data[End Date]
        )
    VAR result =
        SUMX (
            dates,
            SWITCH (
                'Calendar'[DayOfWeek],
                1, data[Monday Hours],
                2, data[Tuesday Hours],
                3, data[Wednesday Hours],
                4, data[Thursday Hours],
                5, data[Friday Hours],
                6, data[Saturday Hours],
                data[Sunday Hours]
            )
        )
    RETURN
        result
)

let
  data = Excel.CurrentWorkbook(){[ Name = "data" ]}[Content],
  addFilter = Table.AddColumn (
    data,
    "filter",
    each [
      txt = Text.Lower ( [Столбец1] ?? "" ),
      res =
        if Text.Contains ( txt, "начало" ) then
          1
        else if List.AnyTrue ( List.Transform ( { "конец", "закрытие" }, ( x ) => Text.Contains ( txt, x ) ) ) then
          2
        else
          null
    ][res]
  ),
  addFilter_2 = Table.DuplicateColumn ( addFilter, "filter", "filter_2" ),
  fillDown = Table.FillDown ( addFilter_2, { "filter" } ),
  filter = Table.SelectRows ( fillDown, ( r ) => r[filter] = 1 and r[filter_2] = null and r[Столбец1] <> null ),
  delFilters = Table.RemoveColumns ( filter, { "filter", "filter_2" } )
in
  delFilters

Кол-во:=
CALCULATE (
    SUM ( data[Количество] );
    KEEPFILTERS ( data[Наименование] IN VALUES ( dim_color[Наименование] ) )
)

Кол-во:=
CALCULATE (
    SUM ( data[Количество] );
    CROSSFILTER ( dim_product[Наименование]; dim_color[Наименование]; BOTH )
)