need help with >> IF ( seach or left

[Hikmet_JCI]

Hi

need a column where we searched in one column and in another column starts from the left but related to order number

example :
if the item text is "tee" or item starts with "10" then at order number level yes otherwise blank

??

thank you thank you

[tackytechtom · Accepted solution]

I see.

How about this:

TomsMeasure1 = 
IF ( 
    CALCULATE ( 
        MAX ('Table'[TomsNewColumn1] ), 
        ALLEXCEPT ( 'Table','Table'[OrderNr] ) ) = "yes", 
        CALCULATE ( 
        MAX ('Table'[TomsNewColumn1] ), 
        ALLEXCEPT ( 'Table','Table'[OrderNr] ) ),
        "" 
)

I used a measure now referring to TomsNewColumn1

Was it this you were looking for?

/Tom

https://www.tackytech.blog

https://www.instagram.com/tackytechtom

[Hikmet_JCI]

i need help here!!!

I would have to expand this
TomsNewColumn1 =
IF (
LEFT ( 'Table'[Item], 2 ) = "10" || CONTAINSSTRING( 'Table'[Item Text], "tee" ),
"yes",
BLANK()
)

what i want to do :
two fixed parameters IF ( LEFT ="10" ) and item text "Black" occurs
two additional variable parameters CONTAINSSTRING (Item Text "x1") or (Item Text "x2")

that's not how it works :
IF ( LEFT ( 'Table'[Item], 2 ) = "10" &&
CONTAINSSTRING( 'Table'[Item Text], "black" ) &&
CONTAINSSTRING( 'Table'[Item Text], "black" ) or ( 'Table'[Item Text], "black" )
"yes",
BLANK()
)

[tackytechtom · Accepted solution]

Hi @Hikmet_JCI ,

It is not very clear to me what your additional constraint logic is, but I'll give it a shot:

IF(
    LEFT ( 'Table'[Item], 2 ) = "10" &&
    CONTAINSSTRING( 'Table'[Item Text], "black" ) &&
    ( CONTAINSSTRING( 'Table'[Item Text], "x1" ) || ( 'Table'[Item Text], "x2" ) ),
     "yes",
     BLANK()
)

/Tom

https://www.tackytech.blog

https://www.instagram.com/tackytechtom

[Hikmet_JCI]

thanks

[tackytechtom]

Hi @Hikmet_JCI ,

If either of the two tables fulfill your requirement, then see DAX code below:

TomsNewColumn1 = 
IF ( 
    LEFT ( 'Table'[Item], 2 ) = "10" || CONTAINSSTRING(  'Table'[Item Text], "tee" ), 
    "yes", 
    BLANK() 
)

TomsNewColumn2 = 
IF ( 
    LEFT ( 'Table'[Item], 2 ) = "10" || LEFT (  'Table'[Item Text], 3 ) = "tee", 
    "yes", 
    BLANK() 
)

The first code snippet returns "yes" if Item starts with 10 or Item text contains "tee", while the second returns "yes" if item starts with 10 or item text starts with "tee".

Hope this helps! 🙂

/Tom

https://www.tackytech.blog

https://www.instagram.com/tackytechtom

[Hikmet_JCI]

thank you
now the splate should be added because the same order number

[tackytechtom · Accepted solution]

I see.

How about this:

TomsMeasure1 = 
IF ( 
    CALCULATE ( 
        MAX ('Table'[TomsNewColumn1] ), 
        ALLEXCEPT ( 'Table','Table'[OrderNr] ) ) = "yes", 
        CALCULATE ( 
        MAX ('Table'[TomsNewColumn1] ), 
        ALLEXCEPT ( 'Table','Table'[OrderNr] ) ),
        "" 
)

I used a measure now referring to TomsNewColumn1

Was it this you were looking for?

/Tom

https://www.tackytech.blog

https://www.instagram.com/tackytechtom

[Hikmet_JCI]

great thank you !!!!