Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
62 |