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

[Anonymous]

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!

[v-deddai1-msft]

Hi @Anonymous ,

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

[Fowmy]

@Anonymous 

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