Select highest level identifier

[Syndicate_Admin]

Good morning

I have a table similar to the following, there are operators with different levels, each operator can have several levels and I want to stay with each operator and its highest level. Someone who can help me? I have table 1 and I want to have table 2.

Table 1

id	level
100	2
100	3
101	1
102	2
103	1
103	2
104	2
104	1
104	3

Table 2

id	level
100	3
101	1
102	2
103	2
104	3

Thank you all very much for the help.

[Syndicate_Admin]

Thank you very much for the help. It works perfectly for me.

[Arul · Accepted solution]

@Syndicate_Admin ,

Please try this DAX as a new table.

Table 2 =
SUMMARIZE ( 'Table 1', 'Table 1'[id], "Level", MAX ( 'Table 1'[level] ) )

Output:

Thanks,