Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |