Forum Discussion
Dynamic table to calculate team overload
Hi everyone, I'm not advanced user in Power BI, but I got a request from my manager, that I don't know if it's even possible to do that in Power BI. I have to split team overload demending on te...
Hi Anonymous,
What I can find for Question 1 is a calculated table. Please try it out.
Table = ADDCOLUMNS ( FILTER ( CROSSJOIN ( SELECTCOLUMNS ( JIRA, "Assignee", [Assignee], "Effective hours", [Effective hours], "IssueKey", [IssueKey], "Start date", [Start date], "DUEDATE", [DUEDATE], "Remaining estimate", [Remaining estimate], "date diff", [date diff], "IndexNew", [IndexNew], "SUMMARY", [SUMMARY] ), SELECTCOLUMNS ( 'Calendar', "Date", [Date] ) ), [Date] >= TODAY () && [Date] <= EDATE ( TODAY (), 2 ) ), "dd", [Solution] )
Regarding question 2, I would suggest you create a new thread in this forum.
Best Regards,
Dale
Hi, v-jiascu-msft
I moved calculation to production, everything works fine, exept those task wich have no start date, there are always - 0 hours.
I tried calculations in Excel everything works fine, but in Power BI they dosen't count, where could be the problem?
Link to excel file:
https://drive.google.com/open?id=1X8xDzloVxGz6mFoXsjmWFYJs7M4oUn1S
Hi Anonymous,
Can you share the .pbix file directly? Please mask the sensitive parts.
1. Where is [Effective hours]?
2. Did you add the index?
Best Regards,
Dale