Max of sum of sales per week

[PetrK]

Hi,
please for explanation how to write dax formula for:

I need get max value from sums of sold products per week.
This final value will be used as max value of y-axis for combo chart.
I have several salled product per week but it is written sale by sale. It should be clear from the tabel.

date	week	sold products	sold products per week	max of week sell
01.01.2023	1	5	30	103
01.01.2023	1	2	30
03.01.2023	1	6	30
04.01.2023	1	1	30
05.01.2023	1	5	30
05.01.2023	1	3	30
07.01.2023	1	8	30
08.01.2023	2	5	103
09.01.2023	2	4	103
12.01.2023	2	2	103
12.01.2023	2	6	103
12.01.2023	2	82	103
13.01.2023	2	1	103
14.01.2023	2	3	103
16.01.2023	3	6	84
16.01.2023	3	8	84
17.01.2023	3	1	84
18.01.2023	3	55	84
19.01.2023	3	3	84
20.01.2023	3	11	84

[PetrK]

thank you, it is great.

[ThxAlot · Accepted solution]

For fun only, a showcase of power of Excel formulas, week column isn't necessary.

Of coz, DAX is born for such kind of scenario,