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))
Go to Solution.
Hi @vitormc ,
Establish relationships based on [Employee no] as below.
Add relative data fields into table visual.
View solution in original post
How would you connect this model if you were to add in a Time Dim Table?
Please eloborate your requirement with sample data and desired output.
How to Get Your Question Answered Quickly
Question updated... thank you
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.