Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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],",")
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |