Forum Discussion

spencer_g's avatar
spencer_g
Helper I
10 years ago
Solved

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!

Need Help
  • spencer_g's avatar
    spencer_g
    10 years ago

    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

  • spencer_g's avatar
    spencer_g
    Helper I
    10 years ago

    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.