Forum Discussion
abc_777
Solution Specialist
Solution Specialisthi
Hello, Here I have a few sample data. C_ID C_PHONE B_POINT 16015 161622020 151.2176 60154 161622020 744.0992 60021 131619522 61.9386 60121 131619522 3452.1312 9243...
PBI file attached.
Hope this helps.
Ashish_Mathur
Super User
Super UserPBI file attached.
Hope this helps.
abc_777Solution Specialist
Solution SpecialistAshish_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