Forum Discussion
Solved
Return all values appearing in a given column
Hi, I need a column that returns all the values that appear in the "Class" column according to the "City" column, for example: City Class Result New York A A,B,C New York B A...
Use this formula:
let
Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
#"Added Custom" = Table.AddColumn(Source, "Custom", each Text.Combine(List.Distinct(Table.SelectRows(Source,(x)=>x[City]=[City])[Class]),","))
in
#"Added Custom"
Doesn't work,
In my case I just need create a custom colunm not a table, do you can help me?
OBS: reinforcing that this example is just a slice of the data colunm, I have a much data in colunm City and Class, I just need a custom colunm with the logic.