cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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!

2 REPLIES 2
Highlighted
Community Champion
Community Champion

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

@RebeccaMeng 

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

Highlighted
Microsoft
Microsoft

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

Announcements
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.

secondImage

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