Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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])
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
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])
Hi @halfglassdarkly
Did not get yours to work , but with small modification as below it worked .
Thanks so much
Found the solution:
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])
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |