Forum Discussion
Relation between 3 tables
Hey everyone, I have a file of three tables of mediocre quality. Therefore, it's difficult to get the data I want. In the table Employee, I have a column with the hours they work per week. A...
Anonymous , Try a measure like
AverageX(summarize(Hours, employee[Employee ID], Date[Year and Week No], "_1", sum(Hours[hours worked]) , "_2", Max(Hours Worked Per Week])), divide([_1],[_2]))
Hey amitchandak ,
Thanks for your reply. Unfortunately, it doesn't work. So, I've made a dummy data set and a pbix-file. You can find the links below:
Excel-file:
PBIX-file
https://drive.google.com/file/d/1pWUBc-rNLpo7u2AR3DiZuWPGZjIunZbA/view?usp=sharing