Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
kalpanaV
Helper IV
Helper IV

Need Help

Capture.PNG

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
Anonymous
Not applicable

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

8.PNG

 

 

Regards,

Xiaoxin Sheng

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

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())

 

6.PNG

 

3. Write measurs to calculate the change count.

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

7.PNG

 

 

Regards,

Xiaoxin Sheng

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/.?

Anonymous
Not applicable

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

8.PNG

 

 

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.

Anonymous
Not applicable

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

8.PNG

 

 

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.