Values between two dates not working

[yaman123]

Hi, 

I have the below measure to calculate the values from another table between two dates from a a different table - 

CALCULATE(

SUM('Weekly Adjustments'[CF$_VARIANCE_FIGURE]),

'Weekly Adjustments'[CF$_DATE_FROM] >= MIN('KPI Service Level Query'[DELIVERY_CONFIRMED_DATE]) && 'Weekly Adjustments'[CF$_DATE_TO] <= MAX('KPI Service Level Query'[DELIVERY_CONFIRMED_DATE]))

I have a date slicer set to between with the delivery confirmed date. If i select 03/06/2022 - 09/06/2022, the measure should give me the value of 444. If i select the dates between 27/05/2022 - 02/06/2022, the measure should give me the value of 528. Butr if i select dates between 27/05/2022 - 09/06/2022, the value should be 972. 

When i select the dates between 03/06/2022 - 09/06/2022, this is returning nothing, but there is a value between those dates in the table. 

Is there something i am doing in my measure? 

FYI - the two tables have no links and I dont have a date table. 

Thank

[Anonymous]

HI @yaman123,

Did you mean to calculate with the multiple date fields? If that is the case, you can take a look at the following blog 'start date', 'end date' part:

Before You Post, Read This#start date, end date 

Regards,

Xiaoxin Sheng