Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
Hi,
Try this calculated column formula
="L"&MID([Existing],6,2)
Hope this helps.
Hi,
Try this calculated column formula
="L"&MID([Existing],6,2)
Hope this helps.
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...