Fromdate and Todates - how to use these fields to get results

[dw0012]

I'm having a really hard time with fromdate / todate. I have a table that I created and a month-year slicer. 

The month-year slicer should return any data within the selected month that falls between the from and to dates. The month-year slicer is connected to a DATES table that has an active relationship from 'DATES'[date] to 'TABLE1'[fromdate] and an inactive relationship to to 'TABLE1'[todate]. Currently, when I select May 2024, it only pulls in May dates in the fromdate column as a test. 

[Greg_Deckler · Accepted solution]

@dw0012 Often the easiest way to do this is to use 2 disconnected date tables. You can then use a measure like this:

Measure = 
  VAR __FromDate = MAX( 'FromDates'[Date] )
  VAR __ToDate = MAX( 'ToDates'[Date] )
  VAR __Result = SUMX( FILTER( 'Table', [Date] >= __FromDate && [Date] <= __ToDate ), [Value] )
RETURN
  __Result

If that doesn't work, please provide more information. Also, you can watch this for more information on this kind of scenario: