Forum Discussion
hi
PBI file attached.
Hope this helps.
thanks for your time and try man, But really that not meet my citeria.
What I need is,
1) I want to keep the Customer's Phone number which has the highest Balance Point (Remove Duplicate mobile number as per the highest Balance Point)
Expected Outcome for Highest,
| C_ID | C_PHONE | B_POINT |
| 60154 | 161622020 | 744.0992 |
| 60121 | 131619522 | 3452.131 |
| 90174 | 132281355 | 619.3274 |
| 60156 | 140400500 | 664.8464 |
2) I want to keep the Customer's Phone number which has the lowest Balance Point (Remove Duplicate mobile number as per lowest Balance Point)
Expected Outcome for Lowest,
| C_ID | C_PHONE | B_POINT |
| 16015 | 161622020 | 151.2176 |
| 60021 | 131619522 | 61.9386 |
| 92502 | 132281355 | 0 |
| 16015 | 140400500 | 0 |
| 13003 | 140400500 | 0 |
PBI file attached.
Hope this helps.
Ashish_Mathur thanks mak for your time and effort.
I have used your solution as well as another blog post user
in following screen shot top two tables are your and bottom two are his.
Difference is, for his one i got one customer who has three different id but same phone number and both tables shows me all data with customer name and customer ID
in your solution only the highest and lowest. not with customer name and Id and most important is 290186 is not right.
but its ok. i will again check if i have any issue. really thank you again man for your time and effort