Forum Discussion
Helper IIIRolling up to a single value
I have a table where I want to only show the matching value in column one for all values in column two.
So this first table should be sumarized to the second table below. I'm having trould getting the Table visual to perform this function.
| John Dow | Amazon |
| John Dow | Ebay |
| John Dow | Amazon |
| Ebay |
According to my attempt, it can't be done in table visual.
In table visual, rows correspond to each other, but blank values may correspond to different values in your requirements, resulting in sorting issue.
Column = VAR INDEX_ = RANKX(FILTER('Table (2)',EARLIER('Table (2)'[col1])='Table (2)'[col1]),'Table (2)'[col2]) RETURN IF(INDEX_=1,'Table (2)'[col1],BLANK())
4 Replies
- amitchandak
Super User
MEFOX , not very clear but concatenatex can help
concatenatex(Table, Table[column2], " " )
concatenatex(Table, Table[column2], unichar(10))
MEFOXLooks like the values in my table example was messed up when I hit the send button. I'm resending my example. I want to roll up the values in column 1 for all entrries in column 2.
John Dow Amazon John Dow Ebay John Dow Amazon Ebay - MEFOX
Sorry it happen again when I hit the send button. John Dow is a separate column from Amazon and Ebay.
V-lianl-msftCommunity Support
According to my attempt, it can't be done in table visual.
In table visual, rows correspond to each other, but blank values may correspond to different values in your requirements, resulting in sorting issue.
Column = VAR INDEX_ = RANKX(FILTER('Table (2)',EARLIER('Table (2)'[col1])='Table (2)'[col1]),'Table (2)'[col2]) RETURN IF(INDEX_=1,'Table (2)'[col1],BLANK())
