cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
spencer_g Regular Visitor
Regular Visitor

Filter Report by Max Date

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
spencer_g Regular Visitor
Regular Visitor

Re: Filter Report by Max Date

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. 

1 REPLY 1
Highlighted
spencer_g Regular Visitor
Regular Visitor

Re: Filter Report by Max Date

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.