SUMIFS values between Two Coulmns of Dates In DAX

[Omer_K]

Hey All,
I have 2 databases,
First: Contains a column of start date and end date
Second: Contains a column of date and value
I want to find the result in column C in the first database (column of the result) using the DAX function
The sum of the value of all major dates from start date and major from end date.
In Excel it is possible to do this in SUMIFS but how do I do it in the DAX function?

Attaches the example,

Start Date	End Date	Result			Date	Value
06/04/2020	11/05/2020	1,516			24/02/2021	26,092
14/10/2020	08/11/2020	-			07/07/2019	36,990
14/04/2019	18/05/2019	-			28/12/2020	35,586
04/03/2019	09/03/2019	-			27/12/2019	21,272
08/04/2020	24/04/2020	1,516			13/06/2019	18,555
10/02/2020	28/03/2020	-			20/08/2019	11,049
11/11/2020	30/11/2020	34,879			11/08/2019	30,908
10/11/2020	10/12/2020	34,879			28/02/2021	29,489
22/03/2020	23/04/2020	1,516			20/12/2019	38,344
02/03/2019	09/03/2019	-			26/12/2020	5,592
19/10/2019	27/10/2019	-			01/07/2020	18,256
27/03/2020	09/04/2020	-			04/09/2019	46,605
27/01/2021	17/02/2021	-			19/01/2020	23,530
04/05/2020	19/06/2020	33,684			18/12/2019	48,177
30/01/2021	10/03/2021	100,798			25/08/2019	34,663
08/11/2019	13/11/2019	-			02/08/2019	10,881
16/04/2019	13/05/2019	-			18/03/2019	47,711
23/02/2020	16/03/2020	-			13/04/2020	1,516
25/11/2020	06/12/2020	34,879			28/07/2020	44,738
11/12/2019	31/12/2019	107,793			04/09/2020	35,446
31/03/2019	06/05/2019	-			29/11/2020	34,879
21/02/2019	29/03/2019	47,711			16/06/2020	33,684
					05/06/2019	40,183
					27/02/2021	45,217

Thank you

 

[mart37]

=SUMX(FILTER(Table2,Table1[Start Date]<=Table2[Date]&&Table1[End Date]>=Table2[Date]),Table2[Value])

 

[Omer_K]

Hey mart37,
Thank you for the answer
how i can connection between the two tables - ths dates are reapte in both tables..

 

[Omer_K]

When I use the filter function it does not recognize the columns in the first table

 

[mart37]

I have no relation between the two tables.
I used a calculated column.
The empty rows are not visible in a pivot table.
When you want to show the empty rows: =0+SUMX(FILTER(Table1[Result1]Table2,Table1[Start Date]<=Table2[Date]&&Table1[End Date]>=Table2[Date]),Table2[Value])

 

[Omer_K]

Dear mart,
You were right about your first answer - you are the Best ?
Appreciate it a lot! ???
Thank you