DAX help for dates

Hi,

Thank you for the information and answer. Please see below a table as an example, please let me know if you need more information.

I have a fact table holding information about Archivierungsdatum, Wareneingangsdatum and EKW netto. For that table I have a Date table connected on the Archivierungsdatum.

I would like to have a table visual for example, where next to the date from my Date table there is the sum of the EKW netto with the following logic implemented:

Next to the date 3 rd of Oct (let's take that date as an example), I can find the sum of the EKW netto, where Archivierungsdatum is equal or bigger than the Date (than 3rd October) - so sum of the netto where Archivierungsdatum is 3rd October and 4th October in our example -, and Wareneingangsdatum is smaller than the Date (so in our example smaller than 3rd October).

So based on our table the sum I would like to see for 3rd Oct is 14.349.448,43.

One more information: I have a big fact table so when I have tried (unsuccesfully) to use SUMX and FILTER in another measure it caused some performance problem:(

Thank you again for all of your support/answer and wishing you a nice evening/day.