Forum Discussion

KL718's avatar
KL718
Frequent Visitor
7 years ago
Solved

Extract distinct values from cell

HI, I have data refer data in column "Names". I need output which is shown in Distinct Values. I do not need Measure, need calculated column. Thanks in advance

 

NamesDistinct Values
AABBC3
AA1
AB2
DF2
DDDE2
Need Help
Show and Tell
Tips and Tricks
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    KL718 

     

    Minor correction.

    This works with me

     

    separateletters = 
COUNTROWS (
    SUMMARIZE (
        ADDCOLUMNS (
            GENERATESERIES ( 1, LEN ( [Names] ) ),
            "letter", MID ( [Names], [Value], 1 )
        ),
        [letter]
    )
)

3 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    7 years ago

    KL718 

     

    Try this calculated column

     

    separateletters =
COUNTROWS (
    SUMMARIZE (
        ADDCOLUMNS (
            GENERATESERIES ( 1, LEN ( [Names] ) ),
            "letter", MID ( [Text], [Value], 1 )
        ),
        [letter]
    )
)
    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      7 years ago

      KL718 

       

      Minor correction.

      This works with me

       

      separateletters = 
COUNTROWS (
    SUMMARIZE (
        ADDCOLUMNS (
            GENERATESERIES ( 1, LEN ( [Names] ) ),
            "letter", MID ( [Names], [Value], 1 )
        ),
        [letter]
    )
)