Forum Discussion

Wresen's avatar
Wresen
Icon for Post Patron rankPost 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
Icon for Responsive Resident rankResponsive Resident
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
    Icon for Post Patron rankPost Patron
    3 years ago

    Thanks so much halfglassdarkly 

    really appriciate it 🙂