Filtering a table with the selection of another one

[LAndris]

Hello

I have been working on a way to filter a range of date period, from 2016Q1-2018Q4, by a selected value as the max period that will be displayed while keeping all periods prior. I have been trying to use a seperate table to filter these periods however I can only get them to filter the single selected period or they don't work. The code below was what I saw online but it doesnt seem to work when I try it.

DAX:

CALCULATE( Values( DatePeriod), Filter( Table1, Table1[DatePeriod] <= Values(Filter)))

The result I am looking for is that the top column would only show up to the selected date if that is even possible.

[Greg_Deckler · Accepted solution]

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...