cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

SLA project

Hello there,

 

We're starting a project & have multiple SLA's from different countries. There are some groups that require more than just 2 letters as abreviations (Austria - AT; Group #1 - HG; etc.). Unfortunately we have set the formula up to search for the first 2 letters in order to assign each incoming case to the specific country, but when cases are coming in from groups that have the same first 2 letters the formula doesn't know how to arrange them correctly. If we set the formula up for the first 3 letters of the countries/groups then it has difficulty assigning the regular cases from AT/NL/PT/UK.

 

Is there something we can add to the formula in order to keep this valid for groups that have the same first 2 letters or try to improve it for the first 3 letters (take into consideration that adding space after the country abreviation is not recognized).

 

Regards,

Liviu

2 REPLIES 2
Community Support Team
Community Support Team

Re: SLA project

@Anonymous ,

 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Slicer-that-returns-distinct-values-of-delimited-string/m-p/202581#M89146

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: SLA project

Thank you for the reply.

 

Unfortunately, this doesn't solve our issue. We've done it & we don't need just a replication of a vlookup formula, but a combination of 2 vlookup formulas so that when it gets the case with the same 2 first letters then it looks in another location in order to know which of the 2 groups it's from.

 

Case A (CG#1 - Country Group #1)

Case B (CG#2 - Country Group #2)

We need the formula to also look in another column with the Company Code to know which CG is from.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 432 members 4,164 guests
Please welcome our newest community members: