Problem with Combined Database and Excel data

[Marcus_S]

Good Morning,

I have accumulated data, which are obtained from a database and an Excel file. The comparison of the last years should be shown.
Everything works fine, except for the year 2020.
There the change from Excel file to database took place.
How can I make it so that the data from the two sources are also cumulated?
Thank you

Greetings Marcus

kumulativ = CALCULATE(SUM('Capacity Ledger Entry'[Output Quantity]) ,FILTER(ALL('Capacity Ledger Entry'),'Capacity Ledger Entry'[Produktionsdatum]<=MAX('Capacity Ledger Entry'[Produktionsdatum])),'Capacity Ledger Entry'[Variant Code] <> BLANK(), VALUES('Capacity Ledger Entry'[Year])) + CALCULATE(SUM('Auswertung 2020'[Quantity produced]), FILTER(ALL('Auswertung 2020'), 'Auswertung 2020'[Datum]<=MAX('Auswertung 2020'[Datum])), VALUES('Auswertung 2020'[YEAR]))

[amitchandak]

@Marcus_S , If you have date then use date table to join with date then try a measure like.

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))