cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dandavey Frequent Visitor
Frequent Visitor

Get Most Recent Value

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Get Most Recent Value

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

 

image.pngimage.png



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





4 REPLIES 4
Highlighted
Super User
Super User

Re: Get Most Recent Value

@dandavey  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.



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





dandavey Frequent Visitor
Frequent Visitor

Re: Get Most Recent Value

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)

Graph.PNGGraphPowerBi.PNGTable

Super User
Super User

Re: Get Most Recent Value

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

 

image.pngimage.png



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





dandavey Frequent Visitor
Frequent Visitor

Re: Get Most Recent Value

Perfect, thanks!