Problem with calculate value in different table

[Supermat]

In this table (LINEE) i have my product lines

Tipo_Linea

L20

L21

L22

L23

L24

L25

L26

L27

L28

L29

L30

L32

L33

S03

S04

S05

S06

S07

S08

S09

S12

S13

S14

S15

S16

S17

S19

S31

S34

S35

S36

In this table (DURF) there are phases duration (some machines have two or three phases)

Tipo_Linea	Lead_Time
L20	1
L21	1
L22	1
L23	1
L24	2
L24	1
L25	1
L26	2
L26	1
L27	1
L28	1
L29	1
L30	1
L32	1
L33	2
L33	1
S03	1
S04	1
S05	1
S06	1
S07	2
S07	1
S08	2
S08	2
S09	2
S09	2
S12	1
S13	1
S14	1
S15	3
S15	1
S16	4
S16	3
S17	2
S17	3
S19	2
S19	2
S31	1
S34	2
S34	2
S35	5
S35	1
S36	5
S36	1

In this table (PDPMA00F) i have machines and i want sum "start date" with a sum of all phase durations to have a potential finish date.

Stabilimento	Scheda_Tecnica	Custumer_number	Order	Data_consegna_cliente	start_date	Serial	qta	Linea	Tipo_linea
01	940002.099	E00010	21005610	24/11/2021	08/11/2021	SPXT-01303	1	800	S07
01	940006.060	E00010	21004139	05/11/2021	27/10/2021	SPHG-00271	1	900	S19
01	930014.373	E00010	21006669	14/02/2022	21/12/2021	SP12-02116	1	1201	S31
01	960006.605	E00010	21006669	14/02/2022	27/01/2022	LA50-03286	1	L4	L27
01	960001.295	E00010	21006669	14/02/2022	19/01/2022	LA51-02831	1	L5	L20

[Supermat]

Hi, thx for your patience.

Here we are: i need to cumulate values in DURF TABLE group by TIPO_LINEA and then i want to use this result in PDPMA TABLE. i need to sum this new value with DATA_MESSA_MONTAGGIO to add the days that will be necessary to complet out product.

If you want you can download dataset here https://www.dropbox.com/s/xmcopr0ln3k1e39/Calendario%20consegne.pbix?dl=0

Sorry for my bad english 😞

[Supermat]

Hi, 

In DURF table i have the same element with different value, i want to sul those value to have how many day i need to make a new machine and then i want to sum that value with start date to see the end date.

[PaulDBrown]

Sorry, I'm finding it hard to follow. Can you recreate the outpu in excel and post the screenshot please?

[PaulDBrown]

Can you please post a depiction of the expected output?