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
v-chuncz-msft
Community Support
Community Support

@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

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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors