Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I've a table with ID, Hours of Working and Date of Working.
I'd like to calculate the completion rate for each ID for each month, like:
ID H DATE
1 2 30 JANUARY 2021
1 3 31 JANUARY 2021
1 2 01 FEBRUARY 2021
ID 1 took 7 hours of work, 5 h in january and 2 h in february. Completion Rate in January 5/7 = 71%
I need this % to divide costs and revenues according to this % (true revenue in january 100.000 € * 71%)
I'd prefer solving this with a measure but a calculated column is also fine.
Thanks
Solved! Go to Solution.
@Luca2020 , You can measure like
divide(Sum(Table[H]), calculate(Sum(Table[H]), filter(allselected(Table), Table[ID] = max(Table[ID]))))
Then multiply that with revenue
divide(Sum(Table[H]), calculate(Sum(Table[H]), filter(allselected(Table), Table[ID] = max(Table[ID])))) * sum(Table[Revenue])
@Luca2020 , You can measure like
divide(Sum(Table[H]), calculate(Sum(Table[H]), filter(allselected(Table), Table[ID] = max(Table[ID]))))
Then multiply that with revenue
divide(Sum(Table[H]), calculate(Sum(Table[H]), filter(allselected(Table), Table[ID] = max(Table[ID])))) * sum(Table[Revenue])
User | Count |
---|---|
70 | |
46 | |
21 | |
21 | |
15 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
24 |