Power BI - Max index using Type and ID

[Raj1313]

Hi,

i am trying to get the max ID using Type and Index in edit queries

I have the below data set

ID	TYPE	INDEX
301	A	1
301	A	2
302	A	3
302	A	4
303	B	5
304	B	6
305	B	7

The result should be:

ID	TYPE	INDEX
302	A	4
305	B	7

Any ideas?


Thanks in advance

 

[sandy666]

ID	TYPE	INDEX		ID	TYPE	Index
301	A	1		302	A	4
301	A	2		305	B	7
302	A	3
302	A	4
303	B	5
304	B	6
305	B	7

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Group = Table.Group(Source, {"TYPE"}, {{"ID", each List.Max([ID]), type number}, {"Index", each List.Max([INDEX]), type number}}),
    TSC = Table.SelectColumns(Group,{"ID", "TYPE", "Index"})
in
    TSC

 

[rsj88]

Hi Sandy, thanks for this - worked perfect!! (i was not able to message from my original account above)

Thanks again

 

[sandy666]

sure
Are you happy?

 

[rsj88]

Yes - Thank you!!

 

[sandy666]

You are welcome
Have a nice day