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

     

halfglassdarkly's avatar
halfglassdarkly
Responsive Resident
3 years ago

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

Hi halfglassdarkly 
Did not get yours to work , but with small modification as below it worked .
Thanks so much