summarize table by max date

[mahendran2006]

Hi All,

I have two tables, date table and invoice table. my requirement is to show the unique recent invoice data by refreshed date.

if i put week column from date table it has to show the unique data from that week, if i put month it has to show the unique data from that month.

 

Thanks 

Mahendran 

[mahendran2006]

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

[mahendran2006]

week	Invoice	Invoice refresh date	max refresh date
WKS 01st Apr 2024	1111	4/5/2024	John
WKS 01st Apr 2024	2222	4/5/2024	Peter
WKS 01st Apr 2024	3333	4/5/2024	Charles
WKS 01st Apr 2024	4444	4/5/2024	Cathy
WKS 08th Apr 2024	1111	4/8/2024	John
WKS 08th Apr 2024	2222	4/8/2024	Peter
WKS 08th Apr 2024	3333	4/8/2024	Charles
WKS 08th Apr 2024	4444	4/8/2024	Cathy
WKS 22nd Apr 2024	1111	4/22/2024	John
WKS 22nd Apr 2024	2222	4/22/2024	Peter
WKS 22nd Apr 2024	3333	4/22/2024	Charles
WKS 22nd Apr 2024	4444	4/22/2024	Cathy

[mahendran2006]

Month	Invoice	Refresh Date	Name
Apr'24	1111	4/22/2024	John
Apr'24	2222	4/22/2024	Peter
Apr'24	3333	4/22/2024	Charles
Apr'24	4444	4/22/2024	Cathy

[mahendran2006]

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

[Greg_Deckler]

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

[mahendran2006]

Invoice No	RefreshDate	Name
1111	4/1/2024	John
2222	4/1/2024	Peter
3333	4/1/2024	Charles
1111	4/5/2024	John
2222	4/5/2024	Peter
3333	4/5/2024	Charles
4444	4/5/2024	Cathy
1111	4/8/2024	John
2222	4/8/2024	Peter
3333	4/8/2024	Charles
4444	4/8/2024	Cathy
1111	4/22/2024	John
2222	4/22/2024	Peter
3333	4/22/2024	Charles
4444	4/22/2024	Cathy