cancel
Showing results for
Did you mean:
Highlighted
Helper IV

## 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,.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support

## Re: Need Help

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

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Highlighted
Community Support

## Re: Need Help

Hi @kalpanaV,

You can try to use below formula if it suitable for your requirement.

1. Add date column as index to table.

`Date = DATEVALUE([Month]&" "&1)`

2. Add calculated column to calculate the last changed month.

```LastChange =
var previous_Date=MAXX(FILTER(Sheet7,[Date]<EARLIER(Sheet7[Date])&&[Employee_id]=EARLIER(Sheet7[Employee_id])),[Date])
Return
IF(previous_Date<>BLANK()&&[Team Name]<>LOOKUPVALUE(Sheet7[Team Name],Sheet7[Employee_id],[Employee_id],Sheet7[Date],previous_Date),[Month],BLANK())```

3. Write measurs to calculate the change count.

`Change Count = CALCULATE(COUNT(Sheet7[LastChange]),Sheet7[LastChange]<>BLANK()) `

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper IV

## Re: Need Help

I tried it, it s giving wrong values.

Else, can we get  like this

100 -Monitoring, Networking, Montioring

101-  Montioring.DBA, Monitoring

Just i want to list it i table. is this possible/.?

Highlighted
Community Support

## Re: Need Help

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

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper IV

## Re: Need Help

small change, it should not come like this - Monitoring, monitoring,Networking.

it will be good, if it comes like this - Monitoring,networking.

Highlighted
Community Support

## Re: Need Help

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

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

#### Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

#### Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors