Distinct Values and then Max Value related to each row

[kmshah]

We have recieved data from one of our partners where they have given us information about how each of their loans has behaved over it's lifetime. 

We would like to generate a table from them which allows us to extract how many distinct loan ids are there as well as what their maximum loan balance ever was.

e.g. Source Table 

Loan ID	Loan Balance
A	100
A	90
A	80
A	70
B	150
B	140
B	130
B	120
C	180
C	170

And to convert this into:

A	100
B	150
C	180

Any suggestions on how we could do this?

[amitchandak · Accepted solution]

@kmshah , if you use in Min and Max as summarization in visual you should get it ?

Measures like

min Loan Balance = min(Table[Loan Balance])
max Loan Balance = max(Table[Loan Balance])

Or table like

new table = summarize(Table,table[Loan ID],"Min",min(Table[Loan Balance]),"Max",max(Table[Loan Balance]))

[kmshah]

The logic for the table worked perfectly! Thank you @amitchandak