Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sujaymallesh
Frequent Visitor

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

 

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@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]
        )
    )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-chuncz-msft
Community Support
Community Support

@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]
        )
    )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.