Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
juhoneyighot
Helper II
Helper II

Add a Custom Column

Hello!

Please help on how to add a custom Column for this condition. See table below.

I have a column stx_jobtype_txt then I want to get the NC.IN column which is I want it to be a custom column.

stx_jobtype_txtNC.IN
NC 110_Estimates__90CompleteNC
IN 610_CO EQ_Estimate__90CompleteIN
NC.IN 720_Dehu_Estimate__40Contract ExecutedNC.IN
012 Service_Service Call 

Here are the conditions:

1st: if the first 5 characters is equal to "NC.IN" then NC.IN

2nd: if the first 3 characters is equal to "NC " then NC

3rd: if the first 3 characters is equal to "IN " then IN

 

else is blank

 

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

2 REPLIES 2
Ahmedx
Super User
Super User

or try this

Screenshot_3.png

Ahmedx
Super User
Super User

pls try this

Measure = 
VAR Words = MAX('Table'[stx_jobtype_txt])
VAR IN_Word = MAX('Table'[NC.IN])
RETURN
IF( NOT ISBLANK(Words), 
 IF(
TRIM(
LEFT(Words,3))= IN_Word,IN_Word, if (TRIM(LEFT(Words,5))=IN_Word,IN_Word,"")))

Screenshot_2.png

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.