Forum Discussion

sujaymallesh's avatar
sujaymallesh
Frequent Visitor
8 years ago
Solved

4 weeks sales in column

Hello,

 

I want to get last 4 weeks sum of sales in the table. In below example column "Previous 4 week Sales".

 

Please can someone help me here.

 

 

WeekProductSalesPrevious 4 week Sales
1A10 
2A10 
3A20 
4A3070
5A40100
6A50140
7A60180
8A70220
9A80260
10A90300
1B5 
2B5 
3B5 
4B1025
5B1535
6B2050
7B2570
8B3090
9B35110
10B40130

 

  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi sujaymallesh,

     

    Previous 4 week Sales =
IF (
    'Weekly Sales'[Week] < 4,
    BLANK (),
    CALCULATE (
        SUM ( 'Weekly Sales'[Sales] ),
        FILTER (
            ALLEXCEPT ( 'Weekly Sales', 'Weekly Sales'[Product] ),
            'Weekly Sales'[Week] <= EARLIER ( 'Weekly Sales'[Week] )
                && 'Weekly Sales'[Week]
                    > EARLIER ( 'Weekly Sales'[Week] ) - 4
        )
    )
)

     

    Best regards,

    Yuliana Gu

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi sujaymallesh,

     

    Previous 4 week Sales =
IF (
    'Weekly Sales'[Week] < 4,
    BLANK (),
    CALCULATE (
        SUM ( 'Weekly Sales'[Sales] ),
        FILTER (
            ALLEXCEPT ( 'Weekly Sales', 'Weekly Sales'[Product] ),
            'Weekly Sales'[Week] <= EARLIER ( 'Weekly Sales'[Week] )
                && 'Weekly Sales'[Week]
                    > EARLIER ( 'Weekly Sales'[Week] ) - 4
        )
    )
)

     

    Best regards,

    Yuliana Gu