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
gk2go
Helper III
Helper III

Fuzzy match rows within the same table

I have this table:

URL                             | Date         | Type

example.com/victims  | 1/1/2011  | A

example.com/victums | 2/2/2022  | B

example.com/victim    | 3/3/2033  | C

 

I would like it to become:

URL                             | Date         | Type

example.com/victims  | 1/1/2011  | A

 

That is since the URLs are very similar, I want to only keep the one with the earliest Date, the original.

1 ACCEPTED SOLUTION
v-xuding-msft
Community Support
Community Support

Hi @gk2go ,

You could use the option of earlist date in values of fields directly.

2.PNG3.PNG

Best Regards,

Xue

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-xuding-msft
Community Support
Community Support

Hi @gk2go ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here. If it still doesn't work, please share a dummy file that easier for help.

 

Best Regards,

Xue

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-xuding-msft
Community Support
Community Support

Hi @gk2go ,

You could use the option of earlist date in values of fields directly.

2.PNG3.PNG

Best Regards,

Xue

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors