ValuesBetween =
VAR StartDate =
VALUE ( MIN ( Dates[Dates] ) )
VAR EndDate =
VALUE ( MAX ( Dates[Dates] ) )
VAR StartingHour =
FORMAT ( MIN ( Hours[Hours] ), "00" )
VAR EndingHour =
FORMAT ( MAX ( HoursEnd[Hours] ), "00" )
VAR StartingMinute =
FORMAT ( MIN ( Minutes[Minutes] ), "00" )
VAR EndingMinute =
FORMAT ( MAX ( MinutesEnd[Minutes] ), "00" )
VAR StartString = StartDate & StartingHour & StartingMinute
VAR EndString = EndDate & EndingHour & EndingMinute
RETURN
SUMX (
FILTER (
FactTable,
VALUE ( FactTable[Dates] ) & FORMAT ( FactTable[Hour], "00" )
& FORMAT ( FactTable[Minutes], "00" ) >= StartString
&& VALUE ( FactTable[Dates] ) & FORMAT ( FactTable[Hour], "00" )
& FORMAT ( FactTable[Minutes], "00" ) <= EndString
),
FactTable[Value]
)