Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

 

Need Help

4 Replies

  • PattemManohar's avatar
    PattemManohar
    Community Champion
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        PattemManohar
        Community Champion
        7 years ago

        Anonymous  Please add a "Visual Level Filter" as below