Dax if string starts with text

[Alisea_MI]

Hi,

I am new to Power BI and would highly appreciate help with a calculated column that takes the first character from a string, and if it is "7", returns "SMED (7xxx)", if a string starts with "8", returns "SMNA (8...)". Else null.  

Would be grateful for all the help!

[Alisea_MI]

@amitchandak , I hope you don't take offence, both variants work fine, but I only can set one to "correct", so I too the first one.  Thank you once more!

[selimovd · Accepted solution]

Hey @Alisea_MI ,

sure, that's possible.

Add the following calculated column:

My String Check =
IF(
    LEFT( myTable[SempleContractNo], 1 ) = "7",
    "SMED (7xxx)",
    IF(
        LEFT( myTable[SempleContractNo], 1 ) = "8",
        "SMED (8xxx)",
        BLANK()
    )
)

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[AlanP514]

Hi @selimovd 
Thanks for the Idea which you are commented for this post
i am also facing same issue but it need's some more debugging in the dax, i have attached the screen shot appreciate your help on this 

Scenario : I need to create on matrix table in power bi and in the row feild i am using variable names 
So my requirment is if value is "starting" with Budget then one color else another color 

So that users can seggregate the budget and actual in easy way 

but inside table there one text start with Tyre Budget so that i need some idea how to over come this sitation


Thanks 
Hoping Best Solutions
Alan 

[amitchandak]

@Alisea_MI , You Can try a new column

switch(True(),

left([column],1) = "7","SMED (7xxx)",

left([column],1) = "8","SMNA (8...)"

)