DAX Fridays  

This was not my idea, i was asked about it but thanks!! :)

❤️❤️

Let us know if you test it in bigger datasets!

😃

Sometimes you need the data as is. Think ot was complete sentences from a questionnaire instead, you dont want to split them right?

@@CurbalEN ok, let me try asking other way around. You took your original table, made a reference to it, then you extracted unique values after splitting the text in the column. Your way was to split it to another column and then combined the columns into 1 column and extracted the unique values. So what Im asking is - why do it the long way around, when column split function can split it diresctly into rows, so trying to fast recreate this: let Source = Excel.CurrentWorkbook(){[Name="name"]}[Content], #"Split Column by Delimiter" = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Column1.1", "Column1.2"}), #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Split Column by Delimiter", {}, "Attribute", "Value"), #"Removed Other Columns" = Table.SelectColumns(#"Unpivoted Columns",{"Value"}), #"Removed Duplicates" = Table.Distinct(#"Removed Other Columns") in #"Removed Duplicates" this is mostly what you did. so if you would @ 1:04 opened the advanced options, you would see option to split into rows, so basicly this: #"Split Column by Delimiter" = Table.SplitColumn(Source, "Column1", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Column1.1", "Column1.2"}), #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Split Column by Delimiter", {}, "Attribute", "Value"), #"Removed Other Columns" = Table.SelectColumns(#"Unpivoted Columns",{"Value"}), would be replaced with just this: = Table.ExpandListColumn(Table.TransformColumns(Source, {{"Column1", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Column1")