Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
76 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |