March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello Community Need help,
I have a scenario. i have a "product name" column in the below mentioned table.
i want to create a column that should return the list of product names.
that each product repeated more than one time in the column. like below mentioned expected result column.
Need help.
Thank you.
Product name | Date | Expected Result |
HYD0001 | 10/1/2023 | HYD0001 |
HYD0001-MR1 | 10/2/2023 | |
BAN0002 | 10/3/2023 | BAN0002 |
BAN0002-MR1 | 10/4/2023 | |
BAN0002-MR2 | 10/5/2023 | |
CHE0003 | 10/6/2023 | |
DEL0004 | 10/7/2023 | DEL0004 |
DEL0004-MR1 | 10/8/2023 |
@Ashish_Mathur Need help
@CoreyP Need help
Solved! Go to Solution.
Hi @Anonymous ,
Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information and description to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Sorry Actually requirment got changed.
Requirment: which product name having both inital & Recert status. then we should return the initial staus record of that product.
Product name | Status | Expected Result |
HYD0001-MR1 | Initial | HYD0001-MR1 |
HYD0001-MR1 Recert | Recert | |
MUM0001-MR1 | Initial | |
MUM0001-MR1 Insurance | Insurance | |
BAN0002-MR1 | Initial | BAN0002-MR1 |
BAN0002-MR1 Recert | Recert | |
BAN0002-MR2 | Turn | |
CHE0003-MR1 | Initial | |
DEL0004-MR1 | Initial | DEL0004-MR1 |
DEL0004-MR1 Recert | Recert |
pls try this
Hi Ahmedx Could you please provide some other easy solution. User expecting the simple calculation.
what do you mean simple solution?
like formula is unclear to you?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
94 | |
92 | |
91 | |
79 | |
49 |
User | Count |
---|---|
160 | |
144 | |
103 | |
74 | |
57 |