OrderDatetime between Startdatetime and enddatetime

Hi  refint650 ,

Here are the steps you can follow：

If you want to use measure to perform an aggregation operation on the values of two slicer-selected dates, you can use the following measure:

Create measure.

 

Measure =
var _selectstart=SELECTEDVALUE('StartDate'[StartDate])
var _selectend=SELECTEDVALUE('EndDate'[EndDate])
return
SUMX(
    FILTER(ALLSELECTED('Date'),
    'Date'[Order DateTime] >=_selectstart&&'Date'[Order DateTime]<=_selectend),[Rand])

 

If you want [Order DateTime] to show the date between two slicer selections, you can use the following measure:

Create measure.

Flag =
var _selectstart=SELECTEDVALUE('StartDate'[StartDate])
var _selectend=SELECTEDVALUE('EndDate'[EndDate])
return
IF(
    MAX('Date'[Order DateTime])>=_selectstart&&MAX('Date'[Order DateTime])<=_selectend,1,0)

Place [Flag]in Filters, set is=1, apply filter.

 

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly