Forum Discussion

Alisea_MI's avatar
Alisea_MI
Icon for Resolver II rankResolver 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 "8", returns "SMNA (8...)". Else null.  

 

Would be grateful for all the help!

 

 

 

 

 

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
     

     

4 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost 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
      Icon for Post Patron rankPost 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 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Alisea_MI , You Can try a new column

    switch(True(),

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

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

    )

  • Alisea_MI's avatar
    Alisea_MI
    Icon for Resolver II rankResolver II
    5 years ago

    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!