Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Sai0436
Frequent Visitor

Need help, to find the product Names which has repeated more than one time in the column.

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 nameDateExpected Result
HYD000110/1/2023HYD0001
HYD0001-MR110/2/2023 
BAN000210/3/2023BAN0002
BAN0002-MR110/4/2023 
BAN0002-MR210/5/2023 
CHE000310/6/2023 
DEL000410/7/2023DEL0004
DEL0004-MR110/8/2023 


@Ashish_Mathur    Need help
@CoreyP       Need help

 

 

 

1 ACCEPTED SOLUTION
6 REPLIES 6
v-shex-msft
Community Support
Community Support

Hi @Sai0436 ,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Sai0436
Frequent Visitor

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 nameStatusExpected Result
HYD0001-MR1InitialHYD0001-MR1
HYD0001-MR1 RecertRecert 
MUM0001-MR1 Initial 
MUM0001-MR1 InsuranceInsurance 
BAN0002-MR1 InitialBAN0002-MR1
BAN0002-MR1 RecertRecert 
BAN0002-MR2Turn 
CHE0003-MR1Initial 
DEL0004-MR1InitialDEL0004-MR1
DEL0004-MR1 RecertRecert 
Ahmedx
Super User
Super User

pls try this

Screenshot_2.png

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?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.