cancel
Showing results 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

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.

 Week Product Sales Previous 4 week Sales 1 A 10 2 A 10 3 A 20 4 A 30 70 5 A 40 100 6 A 50 140 7 A 60 180 8 A 70 220 9 A 80 260 10 A 90 300 1 B 5 2 B 5 3 B 5 4 B 10 25 5 B 15 35 6 B 20 50 7 B 25 70 8 B 30 90 9 B 35 110 10 B 40 130

1 ACCEPTED SOLUTION
Community Support

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.
Community Support

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.