Complex Date Filter

[bruppert]

Hello,

I want to create a visual level filter (a measure) that filters the rows to a certain date range based on a date selected from a different column.

Both of these columns are in the data set that my report shares a live connection with. In my report, I have created a table that includes the [StartDate] column but not [AsOfDate]. What I want is a filter to only include rows that have [StartDate] after MAX([AsOfDate]) - 3 AND  before MAX([AsOfDate]) + 30.

Thank you!

[v-xuding-msft · Accepted solution]

Hi @bruppert ,

In this scenario, I create a measure to calculate the sum of values in selected date.  If I understand incorrectly, please post the sample data and your expected output.

I create two tables. And there is not a relationship between them.

Measure = CALCULATE(VALUES(Table2[values]),FILTER(ALLSELECTED(Table2[StartDate]), MIN(Table2[StartDate]) >= MAX(Table1[AsOfDate])-3 && MAX(Table2[StartDate]) <= MAX(Table1[AsOfDate]) + 30))

Best Regards,

Xue Ding

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