Forum Discussion

hockey_anderson's avatar
hockey_anderson
New Member
3 years ago

Substring a user entered varchar

I want to be able to substring a varchar that my user enters in the Power BI service. For example, my user enters in a 9 character varchar and I only want to extract the 2nd, 3rd, and 6th character i...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

MID(text,2,2) & MID(text,6,1)

  • hockey_anderson's avatar
    hockey_anderson
    New Member
    3 years ago

    How would I use this DAX on a user entered value in Power BI service?

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

      What visual are you planning to use to capture the user input?

       

      • hockey_anderson's avatar
        hockey_anderson
        New Member
        3 years ago

        I have a visual from the Microsoft store called, 'text search slicer'