Forum Discussion
Post PatronCombine values on each row
Hi and thanks for reading this.
I have a little problem and i have no clue how to do it , it seemed easy when i started to think about it 🙂
I have a tabel like below:
I would like to create a column like the picture below(Yellow column) where i combine All column "store" values on each row.
Thanks so much.
Try adding this as a calculated column:
Comb = CALCULATE(CONCATENATEX('your table name',[Store],"/",1),ALL('your table name'),your table name'[What]=EARLIER('your table name'[What])
6 Replies
halfglassdarklyResponsive Resident
Try adding this as a calculated column:
Comb = CALCULATE(CONCATENATEX('your table name',[Store],"/",1),ALL('your table name'),your table name'[What]=EARLIER('your table name'[What])
WresenThanks so much halfglassdarkly
really appriciate it 🙂
- Wresen
Hi again
halfglassdarklyIt worked as i asked for but found a thing that i did not want .
It is possible to do the the store value unique.
If i would have like below:
Comb on Red will A/A/B
I would like it to be only A/B- Wresen
Found the solution:
Comb =CALCULATE(CONCATENATEX(DISTINCT('Table'[store]),'Table'[store],"/",1),ALL('Table'),'Table'[What]=EARLIER('Table'[What]) ) - halfglassdarkly
Try this and see if it works for you:
Comb = CALCULATE(CONCATENATEX(DISTINCT('your table name'),[Store],"/",1),ALL('your table name'),your table name'[What]=EARLIER('your table name'[What])- Wresen
Hi halfglassdarkly
Did not get yours to work , but with small modification as below it worked .
Thanks so much