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,
I am having a little trouble finding the answer to this DAX.
I wish to sum the total availaible hours, how would I stop the avalble summing to 16?
Task | Resource | Start | End | Available | Worked |
Project 1 | Name 1 | 01/01/2019 | 01/01/2019 | 8 | 4 |
Project 1 | Name 1 | 01/01/2019 | 01/01/2019 | 8 | 5 |
Resource Table | Capacity | ||||
NAME | 8HRS | ||||
Date Table | Capacity | ||||
Date | 8HRS |
Regards
Steve
Solved! Go to Solution.
Hi,
You may downloaded my PBI file from here.
Hope this helps.
can you provide more details. It will be helpful, if you provide a sample output you are expecting.
I am looking for it a summary line by the resource
Resource | Available | Worked |
Name 1 | 8 | 9 |
If the resouce worked mutiple days
Task | Resource | Start | End | Available | Worked |
Project 1 | Name 1 | 01/01/2019 | 01/01/2019 | 8 | 8 |
Project 1 | Name 1 | 01/01/2019 | 02/01/2019 | 16 | 16 |
it would sumarize as follows
Resource | Available | Worked |
Name 1 | 16 | 24 |
Hi,
You may downloaded my PBI file from here.
Hope this helps.
how did you get 32?
my mistake should be 24
create new table from Modeling tab and then use the below DAX. Please rename the columns as per your data.
summarizetable2 = SUMMARIZE(Table2,Table2[Resource],"Available",MAX(Table2[Available]),"Hours Worked",SUM(Table2[Worked]))
Am I able to sum only hours worked from Today? I am filtering out the past.
"Hours Worked",SUM(Table2[Worked]))
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |