Forum Discussion
Values between two dates not working
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
1 Reply
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
