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 There,
My Data model as below
Lead | PN | Fac |
MK | X1 | 13 |
MK | X1 | 14 |
MK | X1 | 15 |
MK | Y1 | 13 |
MK | Y1 | 14 |
MK | Y1 | 16 |
I'm trying to modify the above into below.
Lead | PN | Fac |
MK | X1 | 13,14,15 |
MK | Y1 | 13,14,16 |
Its just a sample, I'm delaing with huge dataset though. Could someone please look into it and help me?
Solved! Go to Solution.
@Anonymous , Try a measure like
concatenatex(Table, table[Fac],",")
Hi Amit,
Thanks for your help. Perfect. That solves the issue. Could you please take a look at the below one
Lets say I've two 13's, is there a way to show just 13,14 (not 13,14,13).
Lead | PN | Fac |
MK | X1 | 13 |
MK | X1 | 14 |
MK | X1 | 13 |
Thanks,
Srikanth N
@Anonymous , Try a measure like
concatenatex(Table, table[Fac],",")
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 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |