cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vitormc
Frequent Visitor

Deal with employee transfer and team performance

Hi All,

 

 I have a model with some tables to monitor team performance.

 

The performance is calculated checking the responsible for each task.

Finally we can view the performance by slicers (departments, dates, others). However we need to deal with employee transfer and I am not able to work with it.

 

 In example below, my goal is to have a measure to count task, that could be sliced by employee, by department, by dates...

 

When viewing tasks by department I want to count only the tasks that occuried while employee was linked to the department.

 

Tables and result see images... (cannot publish))

result.pngtables.png

 

1 ACCEPTED SOLUTION
v-yulgu-msft
Microsoft
Microsoft

Hi @vitormc ,

 

Establish relationships based on [Employee no] as below.

1.PNG

 

Add relative data fields into table visual.

2.PNG4.PNG

Best regards,

Yuliana Gu

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

View solution in original post

4 REPLIES 4
hng
Regular Visitor

How would you connect this model if you were to add in a Time Dim Table?

hng_0-1630446755992.png

 

v-yulgu-msft
Microsoft
Microsoft

Hi @vitormc ,

 

Establish relationships based on [Employee no] as below.

1.PNG

 

Add relative data fields into table visual.

2.PNG4.PNG

Best regards,

Yuliana Gu

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

View solution in original post

v-yulgu-msft
Microsoft
Microsoft

Hi @vitormc ,

 

Please eloborate your requirement with sample data and desired output.

How to Get Your Question Answered Quickly

 

Regards,

Yuliana Gu

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

Question updated... thank you

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.