Forum Discussion

Brianoreilly's avatar
Brianoreilly
Helper II
7 years ago
Solved

Dynamic Date Slicer: Date Table and Source Table with Two Date Columns

  Hi Community,    I have a problem.   I have a number of measures that I need to build via a method of using a date slicer to sum the value between two dates.  (See Screenshot below).    I n...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Brianoreilly,

     

    You may refer to the DAX below.

    Measure =
SUMX (
    FILTER (
        Timecard,
        Timecard[Start Date] >= MIN ( 'Date'[Date] )
            && Timecard[End Date] <= MAX ( 'Date'[Date] )
    ),
    Timecard[Total Hours]
)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

Brianoreilly,

 

You may refer to the DAX below.

Measure =
SUMX (
    FILTER (
        Timecard,
        Timecard[Start Date] >= MIN ( 'Date'[Date] )
            && Timecard[End Date] <= MAX ( 'Date'[Date] )
    ),
    Timecard[Total Hours]
)