OrderDatetime between Startdatetime and enddatetime

[refint650]

Hello All

how to write expression filter datesbetween startdatetime & enddatetime. 

Thanks

Rs

[Anonymous · Accepted solution]

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

[Pretengineer]

Without know more a typical filter for date you can use DATESVETWEEN.

DATESBETWEEN(table1[coulmn1], startdate , enddate)