Filter Report by Max Date

[spencer_g]

Hello Everyone, 

I have two sets of data (one that is updated more frequently than the other) that I am using to create a report, and I don't want to show data for the more frequently updated data set that is beyond the date range for the less frequently updated set. 

For instance, if Data Set A was last update 06.05.2016, but Data Set B was updated 06.27.2016, I want to filter Data Set B so that only the data up to 06.05.2016 is dipicted across the entire report. 

How can I do this? I know it must include the  = MAX[Date] formula in some way, but I haven't been able to figure it out. 

Thanks in advance for any help on this!

[spencer_g · Accepted solution]

Found the answer. I was making it more complicated than it needed to be.

You have to create a new column:

Rprt Date Filter = IF('A General Usage'[Date] <= MAX('M ApplicationsWeek'[Week Ending]), "Y", "N")

Then use the column "Y's" to filter the page/report.