Possible to show only records of last update date for entire report?

[shinney]

My report contains multiple entries for the same person, with a time stamp of each time it got updated. This is messing up the overall license count, since it's summing up every single row, whereas I only need the latest updated rows. I would need this to apply to my entire report (ie. filters need to reflect this), so I can't just select the 'Latest' aggregate on the visuals.
So for example, if the data contains:

Name	License	Last_Update
Alex	Enterprise	June 1, 2021
Alex	Standard	Sept 1, 2021
Bob	Standard	Sept 15, 2021
Cam	Enterprise	Sept 15, 2021
Alex	Professional	Oct 1, 2021

I want only the last 3 rows should show up in my report & visuals.

Is this possible? Thanks.

[jdbuchanan71 · Accepted solution]

@shinney 

You could add a calculated column to your table to flag only the newest updates like this.

Is Newest Update = 
YourTable[Last_Update] = CALCULATE(MAX(YourTable[Last_Update]),ALLEXCEPT(YourTable,YourTable[Name]))

Then apply a filter to your report for [Is Newest Update] = TRUE

[shinney]

Thanks! I couldn't get the Calculate nor the Allexcept functions to work when I'm trying to insert the calculated column as suggested ... but your logic inspired a different formula:

NewestUpdate = If (Table[LastUpdate]=MAX(Table[LastUpdate),True,False).

I then added the filter for NewestUpdate is True on all pages and it seemed to work!