Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
i tried distinct count but it will show count only. i need, which team they have changed.
You may try Pivot Column in Query Editor or the Matrix visual.
okay thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |