Forum Discussion
Contains in Column
I don't understand what the difference is, the principle is the same
1) you must create a table for the slicer, it is not connected to the main table
2) write down the measure and that's it
Contains in Column 2.pbix
Hi Ahmedx,
Thanks for your efforts. Your solution is workign absolutly fine but there are 2 observations in "Contains in Column2 PBIX". Please address the obseravtions.
1. With no selection in Filter why am seeing 30Y2032 ?
2. With no selection i should see all the records in visual table( Table[Id product])
Regards,
Narender.
superb Man.. thanks for quick respose.
Hi ahmed,
here is the full scenario.
below is the source data.
S.no Part number Previous Part number Current Concatenate Change Date Type of change Part Status Prev Wei FSC Curr Wei FSC Prev Tar FSC Curr Tar FSC Qty Prev Qty Curr 1 30Y0140 30Y0140,30Y01XY,30Y0160,30Y0ABC 05-01-23 New cost item New part 10 10 15 17 1 1 2 30Y0140 30Y01XY 30Y0140,30Y01XY,30Y0160,30Y0ABC 06-01-23 Part Replacement Part Change 10 10 15 17 1 1 3 30Y01XY 30Y0160 30Y0140,30Y01XY,30Y0160,30Y0ABC 07-01-23 Part Replacement Part Change 10 10 15 17 1 1 4 30Y0160 30Y0ABC 30Y0140,30Y01XY,30Y0160,30Y0ABC 08-01-23 Part Replacement Part Change 10 20 12 18 1 1 5 30Y1534 30Y1534 11-01-23 New cost item New part 10 10 15 13 1 1 6 30Y1532 30Y1532 12-01-23 New cost item New part 10 10 15 13 1 1 7 30Y0989 30Y0989/30Y0100 13-01-23 New cost item New part 10 10 15 13 1 1 8 30Y0989 30Y0100 30Y0989/30Y0100 14-01-23 Part Replacement Part Change 10 10 15 13 1 1 below table should genearte on basis of group by concateante column adn show the part num based on Minimum change date and maximum chage date with in the group.
Delta is Curr Wei FSC (at minimun date) - Curr Wei FSC (at maximum date).
First part Num last Part Num Delta 30Y0140 30Y0ABC -10 30Y1534 30Y1534 0 30Y1532 30Y1532 0 30Y0989 30Y0100 18 Now if i click on the first row i should show the hostory of changes from 30Y0140 TO 30Y0ABC as below.
S.no Part number Previous Part number Current Concatenate Change Date Type of change Part Status Prev Wei FSC Curr Wei FSC 1 30Y0140 30Y0140,30Y01XY,30Y0160,30Y0ABC 05-01-23 New cost item New part 10 10 2 30Y0140 30Y01XY 30Y0140,30Y01XY,30Y0160,30Y0ABC 06-01-23 Part Replacement Part Change 10 10 3 30Y01XY 30Y0160 30Y0140,30Y01XY,30Y0160,30Y0ABC 07-01-23 Part Replacement Part Change 10 10 4 30Y0160 30Y0ABC 30Y0140,30Y01XY,30Y0160,30Y0ABC 08-01-23 Part Replacement Part Change 10 20 Regards,
Narender.