Forum Discussion

RickL's avatar
RickL
Frequent Visitor
7 years ago
Solved

SUM with a previous value from another column

Hi,   I am wanting to SUM SalesNextYr where TimePeriod = TimePeriod - 100   TimePeriod Customer Ref SalesCurrentYr SalesNextYr 201101 1 100 20 0 201101 1 101 20 10 201101 ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi RickL,

     

    Try these two formulas, please.

    SalesPeriod =
[SalesCurrentYr] + Table1[SalesNextYr]

    CalendarPeriod =
[SalesCurrentYr]
    + CALCULATE (
        SUM ( Table1[SalesNextYr] ),
        FILTER (
            'Table1',
            'Table1'[TimePeriod]
                = EARLIER ( Table1[TimePeriod] ) - 100
                && Table1[Customer] = EARLIER ( Table1[Customer] )
        )
    )

    sum_with_a_previous_value_from_another_column

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi RickL,

 

Try these two formulas, please.

SalesPeriod =
[SalesCurrentYr] + Table1[SalesNextYr]

CalendarPeriod =
[SalesCurrentYr]
    + CALCULATE (
        SUM ( Table1[SalesNextYr] ),
        FILTER (
            'Table1',
            'Table1'[TimePeriod]
                = EARLIER ( Table1[TimePeriod] ) - 100
                && Table1[Customer] = EARLIER ( Table1[Customer] )
        )
    )

sum_with_a_previous_value_from_another_column

 

Best Regards,
Dale