Assistance needed

[kalpanaV]

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.

[TomMartens]

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

[kalpanaV]

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

[v-chuncz-msft]

@kalpanaV,

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

[kalpanaV]

okay thanks