cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kalpanaV Member
Member

Assistance needed

Capture.PNG

Hi

 i want to get the details when they changed to other team.

for eg- if you take id 103 ,  initially in monitoring team and after some days ,changed to linux team in august month.

 

like that i want it for all id's. in which movement has changed and how many has changed.

Thanks in advance.

4 REPLIES 4
Super User III
Super User III

Re: Assistance needed

Hey,

 

from your sample data, you just can DISTINCTCOUNT() the teamname for each employee. This would provide the number of changes. Due to the fact that the column Month will be considered as categorical variable with no implicit sequence you can't calculate how many changes have happened until the current Month.

 

You may consider to change the Month column to the datatype date, eg. 2017-08-01 representing august 2017, now it would be possible to also calculate the number of changes until a specific date, due to the fact that dates have an implicit ordering.

 

Hope this helps somehow

 

Regards

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!
kalpanaV Member
Member

Re: Assistance needed

i tried distinct count but it will show count only. i need, which team they have changed.

Community Support Team
Community Support Team

Re: Assistance needed

@kalpanaV,

 

You may try Pivot Column in Query Editor or the Matrix visual.

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

Re: Assistance needed

okay thanks

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors