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],",")