How to show frequency of combination of numbers within a group?

[Anonymous]

Hello,

I was trying to add these code but the output number is repeated. How to remove the repeating number?

For example 18 18 18 18 -> 18, 13 13 18 18 -> 13 18, 13 18 18 21 21 -> 13 18 21.

Thank you.

Column = CONCATENATEX(FILTER(ALL('Sheet1'),[pick_wave_id]=EARLIER('Sheet1'[pick_wave_id])),[sku_brand]," ")

Measure2 = 
COUNTROWS (
    FILTER (
        VALUES ( 'Sheet1'[pick_wave_id] ),
        CALCULATE ( COUNT ( 'Sheet1'[Column]) >= DISTINCTCOUNT ('Sheet1'[Column]) )
    )
)

[Anonymous · Accepted solution]

Hi @Anonymous ,

I have created a simple sample, please refer to it to see if it helps you.

Create a custom column in Power Query.

=Text.Combine (
                List.Distinct(
                          List.Transform (Text.Split([column]," "),each Text.Trim(_))
                                  )
                     ," ")

If I have misunderstood your menaing, please provide your pbix file without privacy information and desired output with more details.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Power Query new column

Text.Combine(List.Distinct(Text.Split([Column])), " ")

refer in case you need sorted too

Created distinct sorted comma-separated text from unsorted text: https://youtu.be/4bV30FEFjEM

[Anonymous]

Hi@amitchandak 

An error occured when I added the code. Could you help me? Thank you.