Forum Discussion

Alisea_MI's avatar
Alisea_MI
Resolver II
5 years ago
Solved

Dax if string starts with text

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 "...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    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
     

     

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

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
 

 

  • AlanP514's avatar
    AlanP514
    Post Patron
    3 years ago

    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