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 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))
Solved! Go to Solution.
Hi @vitormc ,
Establish relationships based on [Employee no] as below.
Add relative data fields into table visual.
Best regards,
Yuliana Gu
How would you connect this model if you were to add in a Time Dim Table?
Hi @vitormc ,
Establish relationships based on [Employee no] as below.
Add relative data fields into table visual.
Best regards,
Yuliana Gu
Hi @vitormc ,
Please eloborate your requirement with sample data and desired output.
How to Get Your Question Answered Quickly
Regards,
Yuliana Gu
Question updated... thank you
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |