Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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 , 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]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |