Forum Discussion
Solved
Need Help
In this, i want the change in team in repsective month in which month he has changed team and want the count how many has changed,.
Hi kalpanaV,
Please modify the calculated column 'list' to below:
List = CALCULATE(CONCATENATEX(VALUES(Sheet7[Team Name]),[Team Name],","),FILTER(ALL(Sheet7),Sheet7[Employee_id]=EARLIER(Sheet7[Employee_id])))
Regards,
Xiaoxin Sheng
Hi kalpanaV,
>>I tried it, it s giving wrong values.
Can you provide the detailed error message?
>>Just i want to list it i table. is this possible/.?
Yes, it is possible. You can create a calculate column with below formula:
List = CONCATENATEX(FILTER(ALL(Sheet7),Sheet7[Employee_id]=EARLIER(Sheet7[Employee_id])),[Team Name],",")
Regards,
Xiaoxin Sheng
small change, it should not come like this - Monitoring, monitoring,Networking.
it will be good, if it comes like this - Monitoring,networking.
Hi kalpanaV,
Please modify the calculated column 'list' to below:
List = CALCULATE(CONCATENATEX(VALUES(Sheet7[Team Name]),[Team Name],","),FILTER(ALL(Sheet7),Sheet7[Employee_id]=EARLIER(Sheet7[Employee_id])))
Regards,
Xiaoxin Sheng