Forum Discussion

Wresen's avatar
Wresen
Post Patron
3 years ago
Solved

Combine 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...
Need Help
  • halfglassdarkly's avatar
    halfglassdarkly
    3 years ago

    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])

     

Wresen's avatar
Wresen
Post Patron
3 years ago

Hi again
halfglassdarkly 

It 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's avatar
Wresen
Post Patron
3 years ago

Found the solution:

Comb = 
 CALCULATE(CONCATENATEX(DISTINCT('Table'[store]),'Table'[store],"/",1),ALL('Table'),'Table'[What]=EARLIER('Table'[What]) )