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-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    sujaymallesh,

     

    You may add a calculated column as shown below.

    Column =
VAR p = Table1[Product]
VAR w = Table1[Week]
RETURN
    IF (
        w >= 4,
        SUMX (
            FILTER (
                Table1,
                Table1[Product] = p
                    && Table1[Week]
                    > w - 4
                    && Table1[Week] <= w
            ),
            Table1[Sales]
        )
    )

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    sujaymallesh,

     

    You may add a calculated column as shown below.

    Column =
VAR p = Table1[Product]
VAR w = Table1[Week]
RETURN
    IF (
        w >= 4,
        SUMX (
            FILTER (
                Table1,
                Table1[Product] = p
                    && Table1[Week]
                    > w - 4
                    && Table1[Week] <= w
            ),
            Table1[Sales]
        )
    )