DAX Nested IF Statement to search existing column for Certain String Value

[Anonymous]

Good day,

Quite new to Power BI & DAX. Been struggling to get something, which is simple to achieve in Excel (for example) to work.

Essentially, I have a column of data, which for this reference is called [existing], then I would like to make use of a new column and DAX formula to control the output. The new column name would be "NewName" for this example.

The NewName should search in the existing column for a certain string, if that search is satisfied, it should provide me with a value. Refer to the sample below which might explain this a bit better.

If I make use of a single IF statement, I get to my result:

NewName = IF(ISERROR(SEARCH("Zone 00", T1[existing])),"0", "L00")

But, I require a Nested IF Statement to achieve what I'm after and everything which I've tried i.e. AND / OR  & CONTAIN functions which didn't leave me with any luck.

Is there a better way to approach this or are there other functions which I can use which will assist? I will require a DAX solution due to the workflow which I'm setting up.

Thank you in advance!

[Ashish_Mathur · Accepted solution]

Hi,

Try this calculated column formula

="L"&MID([Existing],6,2)

Hope this helps.

[Anonymous]

Thanks @Ashish_Mathur, sometimes the simplest of answers stair us right in the face. Didn't even think of making use of the MID function while trying to overcomplicate my DAX formula...