Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How to get the latest date data from the new table?

Hi Folks,


I have created a new table from the existing table (Office_Info) using the summarize function. I need to group by for Location and Latest Date. However, the result returned all dates total instead of the latest date. I tried many functions, it still not working. Could I know how to make it happened? 


I used 

SUMMARIZE('Office_Info',Office_Info[Location],"Latest Date",MAX(Office_Info[Date]),"Total Cost", sum(Office_Info[Total Cost]))


 Appreciate any help!

Community Champion
Community Champion

Re: How to get the latest date data from the new table?


Your formula is correct. can your share the screenshot of the modal and the table. A sample PBIX will be good.


If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn


Re: How to get the latest date data from the new table?

Hi @RebeccaMeng ,


Your formula works well on my sample data. Would you please show us your sample data or pbix file by onedrive for business?

Then we will help you more correctly.


Please do mask sensitive data before uploading.


Thanks for your understanding and support.


Best Regards,

Dedmon Dai



Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors