YTD difference between 2 dates

[Anonymous]

Dear All

I'm just trying to create a line chart by week that shows a punctual difference between 2 dates and the related YTD.

For the punctual calculation we succeed using also an holiday calendar. Here below the Dax

Ricevimento odv - inserimento CO = 
VAR Ricevimento = MAX('2019'[Data ricevimento odv])
VAR Inserimento = MAX('2019'[Data documento])
RETURN CALCULATE(SUM('CALENDAR'[is work day]),
FILTER(ALL('CALENDAR'[Solar Date]),
'CALENDAR'[Solar Date] >= Ricevimento
&& 'CALENDAR'[Solar Date] <=Inserimento))

The problem is that the cumulated is not working:

Ricevimento Odv - invio CO cumulated = calculate([Ricevimento odv - invio CO],filter(ALLSELECTED('Calendar'),'CALENDAR'[Solar Date]<=MAX('2019'[Data ricevimento odv])))

Here below the relationship between tables and the graph that is not working (the red line)

Any idea?! 

Thanks a lot for your help!!!!

Zeno

[amitchandak · Accepted solution]

@Anonymous , have tried using use relation with datesytd

like this example

YTD 1 = CALCULATE(SUM('CALENDAR'[is work day]),DATESYTD('Date'[Date],"12/31"),USERELATIONSHIP('Table'[Date1];CALENDAR[Date]))

YTD 2 = CALCULATE(SUM('CALENDAR'[is work day]),DATESYTD('Date'[Date],"12/31"),USERELATIONSHIP('Table'[Date2];CALENDAR[Date]))