VAR tbl1 =    ADDCOLUMNS ( SUMMARIZE ( 'Таблица1'; [Дата] ); "MySum"; [value] )

=
VAR tbl1 =
    ADDCOLUMNS ( SUMMARIZE ( 'Таблица1'; [Дата] ); "MySum"; [value] )
VAR a =
    AVERAGEX ( tbl1; [MySum] )
RETURN
    a

VAR CurrDate =
    MAX ( 'DimDate'[Date] )
VAR MyDate =
    DATE ( YEAR ( CurrDate ); MONTH ( CurrDate ); 1 ) - 1
VAR MyVal =
    CALCULATE ( [val]; 'DimDate'[Date] = MyDate )
RETURN
    IF ( ISBLANK ( [val] ); BLANK (); MyVal )

Test1 = var a = 
AVERAGEX(
    ADDCOLUMNS(
        SUMMARIZE ( 
            CALCULATETABLE('Fact') , DimStore[ID] , DimDates[Date] 
        )
        , "MyPlan", [Plan]
        , "MyFact", [Fact]
        , "MyAbsDiff%", ABS ( DIVIDE ([Fact] , [Plan]) - 1)
    )
    , [MyAbsDiff%]
)
return a

Sales PY :=VAR MonthsOffset = 12
RETURN IF (
    [ShowValueForDates],
    SUMX (
        SUMMARIZE ( 'Date', 'Date'[Year Month Number] ),
        VAR CurrentYearMonthNumber = 'Date'[Year Month Number]
        VAR PreviousYearMonthNumber = CurrentYearMonthNumber - MonthsOffset
        VAR DaysOnMonth =
            CALCULATE (
                COUNTROWS ( 'Date' ),
                ALLEXCEPT (
                    'Date',
                    'Date'[Year Month Number],  -- Year Month granularity
                    'Date'[Working Day],        -- Filter-safe Date column
                    'Date'[Day of week]         -- Filter-safe Date column
                )
            )
        VAR DaysSelected =
            CALCULATE (
                COUNTROWS ( 'Date' ),
                'Date'[DateWithSales] = TRUE
            )
        RETURN IF (
            DaysOnMonth = DaysSelected,
 
            -- Selection of all days in the month
            CALCULATE (
                [Sales Amount],
                ALLEXCEPT ( 'Date', 'Date'[Working Day], 'Date'[Day of Week] ),
                'Date'[Year Month Number] = PreviousYearMonthNumber
            ),
             
            -- Partial selection of days in a month
            CALCULATE (
                [Sales Amount],
                ALLEXCEPT ( 'Date', 'Date'[Working Day], 'Date'[Day of Week] ),
                'Date'[Year Month Number] = PreviousYearMonthNumber,
                CALCULATETABLE (
                    VALUES ( 'Date'[Day of Month Number] ),
                    ALLEXCEPT (                      -- Removes filters from all the
                        'Date',                      -- columns that do not have a day
                        'Date'[Day of Month Number], -- granularity, keeping only
                        'Date'[Date]                 -- Date and Day of Month Number
                    ),
                    'Date'[Year Month Number] = CurrentYearMonthNumber,
                    'Date'[DateWithSales] = TRUE
                )
            )
        )
    )
)

=VAR Res1 =CALCULATE (   
[m.sales]   
; DATEADD(DimDates2[Date];-365;day)   
)
RETURN Res1

//VAR CurrDate = MAX(DimDates[Date])
//VAR MaxDate = CALCULATE(MAX(data[date]);DATEADD(data[date];-1;year))
VAR Res1 =
CALCULATE (   
[m.sales]   
; DATEADD(DimDates[Date];-1;YEAR)   
)
RETURN Res1

Measure Cumulative = 
VAR CurrRank = max(Table1[MyRank])
VAR Res = CALCULATE(SUM(Table1[RevByMonth]),Table1[MyRank] <= CurrRank, all(Table1[Store]))
RETURN Res

MyCumulative = 
VAR CurrRank = max(Table1[MyRank])
VAR Res = CALCULATE(SUM(Table1[RevByMonth]),Table1[MyRank] <= CurrRank
    ,all(Table1[Store])
    --,allexcept(Table1,Table1[Date])
    --,allexcept(Table1,Table1[Date],Table1[MyRank],Table1[RevByMonth])
    )
RETURN Res

VAR rank4 = RANKX(Table1,Table1[RevByMonth])

VAR rank5 = CALCULATE(RANKX(Table1,Table1[RevByMonth]),KEEPFILTERS(Table1[Date]))

VAR rank2 = CALCULATE(RANKX(Table1,SUM(table1[RevByMonth])),KEEPFILTERS(Table1[Date]),ALLEXCEPT(Table1,Table1[Store]))

VAR rank3 = RANKX(CALCULATETABLE(ALL(Table1)),SUM(Table1[RevByMonth]))

Rank1 = RANKX(Table1,(SUM(Table1[RevByMonth])))

Rank1 = calculate(RANKX(all(Table1),(SUM(Table1[RevByMonth]))),all(Table1))

= Table.Group(Источник, {"магазин", "дата"}, {
        {"выручка", each List.Sum([сумма]), type number},
        {"выручка_опт", each List.Sum(Table.SelectRows(Источник, each ([тип выручки] = "оптовая"))[сумма]), type number}
    })

table1 =
addcolumns ( 
   summarize ( table, date, store),
   "rev_all", calculate ( sum ( table[sum] ) ),
   "rev_opt", calculate ( sum ( table[sum] ), table[type] = "opt"),
)

RedOrBlack Sales IN :=CALCULATE (
    [Sales Amount],
    Products[Color] IN { "Red", "Black" }
)

RedOrBlack Sales IN :=CALCULATE (
    [Sales Amount],
    Products[Color] IN VALUES(SomeTable[SomeColumn])
)

Sub test()
    
    For i = 1 To 2
        Rows("1:1").Insert Shift:=xlDown
    Next
    
    Range("A1") = "a" & vbNewLine & "b " & vbNewLine & "c" & vbNewLine & "d" & vbNewLine & "e"
    
End Sub

Test1 = VAR MyTable1 = 
    FILTER(
        FILTER (
            ADDCOLUMNS (
                'Сделки', 
                "MinDate1", 
                CALCULATE ( MIN ( 'Сделки'[Дата] ) ,ALLEXCEPT('Сделки','Сделки'[ФИО клиента],'Сделки'[Этап сделки])))
            ,[Этап сделки] = "4. Оплата получена")
        ,[Дата] = [MinDate1]
    )

RETURN COUNTROWS(MyTable1)

Первая покупка = CALCULATE(DISTINCTCOUNT('Сделки'[ФИО клиента]),'Сделки'[Этап сделки] = "4. Оплата получена")

=VAR a = CALCULATE ( COUNTROWS(deals);
      FILTER(deals;
         deals[DATE_CLOSE] >= MAX (DimDateSlicer[DateSlicer])
         && 
         deals[DATE_CREATE] <= MIN(DimDateSlicer[DateSlicer])
         )   )

RETURN  a