summarize table by max date

mahendran2006 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Hi Greg, thanks for helping my query. i have shared my inout table. my expected output table is

Hi Greg,

Thanks for your reply. i have shared the input and output tables. i have the daywise data. if i want to view the data weekly data has to be grouped within that week and has to give the recent refreshed date data.

if i want to view the data monthly data has to be grouped within that month and has to give the recent refreshed date data . in a similar way it has to give for quartely, half yearly, yearly