Forum Discussion

VRMENDESadq's avatar
VRMENDESadq
Frequent Visitor
1 year ago
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...
Need Help
  • ronrsnfld's avatar
    ronrsnfld
    1 year ago

    If you enter that code, by itself, into the Advanced Editor, it will reproduce your data table in your original post, (at the Source step), as well as the final result (at the last step).

     

    If you look at your own query, you will probably also see a Step named "Source" which is where your data comes from.

     

    If your data has the same structure as the sample in your original post, all you should need to do is replace one Source with the other (in the Advanced Editor).

ronrsnfld's avatar
ronrsnfld
Super User
1 year ago

If you enter that code, by itself, into the Advanced Editor, it will reproduce your data table in your original post, (at the Source step), as well as the final result (at the last step).

 

If you look at your own query, you will probably also see a Step named "Source" which is where your data comes from.

 

If your data has the same structure as the sample in your original post, all you should need to do is replace one Source with the other (in the Advanced Editor).

VRMENDESadq's avatar
VRMENDESadq
Frequent Visitor
1 year ago

Thanks its work!!

You are monster of PBI!!