Get Most Recent Value

[Anonymous]

Hi

I have a table which contains entries in the format:

ExtractDate,UserCount,Mail 

When trying to display data in graphs etc. using PowerBi I Desktop want to display the latest entry for "UserCount" (instead it keeps trying to sum the values). How can I do this?

Thanks in advance

[PattemManohar]

@Anonymous  Yes, it will do. As the default behaviour of numeric fields in Power BI is to do Sum. Sample data and expected output will be helpful to suggest you an accurate solution.

[Anonymous]

Hi

So screenshots should be below. Basically for each update to a sheet we want to take the latest values. So want to show how many people have mail out of those in the "OnPremADCount"  (e.g. 500/45590)

GraphTable

[PattemManohar · Accepted solution]

@Anonymous  Please add a "Visual Level Filter" as below

[Anonymous]

Perfect, thanks!