Converting Table to new smaller table with only the latest dates

[JamesCanale]

I'm not strong with Power BI - I have a table with many records for each project, each with a date. I want to make a new table with one record for each project and the latest date for that project. Here is how I would do it in excel. Any help would be great for me - google hasn't helped me yet.

MrExcelPlayground21.xlsx
	A	B	C
1	What I have
2
3	Project	Date	Thing
4	A	12/1/2023	45
5	A	1/1/2024	56
6	A	2/1/2024	451
7	A	3/1/2024	235
8	B	11/1/2023	54
9	B	10/1/2023	486
10	B	11/1/2023	1654
11	B	12/1/2023	165
12	B	1/1/2024	156
13	C	12/1/2023	483
14	C	12/1/2023	15
15	C	1/1/2024	456
16	C	2/1/2024	584
17
18
19	What I want
20
21	Project	Date
22	A	3/1/2024
23	B	1/1/2024
24	C	2/1/2024
Sheet3

Cell Formulas
Range	Formula
A22:A24	A22	=UNIQUE(A4:A16)
B22:B24	B22	=MAXIFS(B4:B16,A4:A16,A22#)
Dynamic array formulas.

 

[JEC]

You can do it with Power Query or DAX.

DAX:

newTable = SUMMARIZE(tbl_Projects,tbl_Projects[Project], "Date", MAX(tbl_Projects[Date]))

PQ:

 grp = Table.Group(previous_Step, {"Project"}, {{"Date", each List.Max(_[Date]), type date}})

Although I think you don't need the extra table. You can use a measure to get the last date for every project.
Create a table on your report page with "Project" as first column. Create a new measure:

M_MaxDate = MAX(tbl_Projects[Date])

Then add the measure to your table.

 

[JamesCanale]

Thanks - this is terrific. I like being on this side of things. I've got a lot to learn, but getting traction is the hardest part.

 

[JEC]

You’re welcome! It is just practicing a lot