Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello All,
What I have to do in this problem is -
I have just used sample of my data but i have more than 1000 employees and I have more than 1 period in my data I just took example of single period and period is YYYYWW (WW-weeknumber of year)
As you can see for a given employee and in a given period, all values of contractual hours are same and value of total hours is different.
So what I need is I want to sum the max of contractual hours for each period for each employee.
For Example if i talk about an employee x then total hours for that employee is Sum(Total hours) and contractual hours is Max(contractual hours) for a given period but what i want is if I am not considering period then contractual hours will be sum of max of contractual hours for each period
Thanks in advance
Hi @Anonymous,
could you provide a sample dataset(not a screenshot), as well as an example using that dataset on what is the desired output?
Cheers,
Sturla
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |