Forum Discussion
PwerQuery is considered Incompleted Status even though Completed is used
| ISSUE_KEY | SPRINT_REPORT_STATUS | ISSUE_TYPE_NAME | SPRINT_NAME |
| ABC-74676 | INCOMPLETED | Task | Sprint 208 |
| ABC-74579 | COMPLETED | Story | Sprint 208 |
| ABC-74585 | COMPLETED | Story | Sprint 208 |
| ABC-74415 | COMPLETED | Task | Sprint 208 |
| ABC-74160 | COMPLETED | Task | Sprint 208 |
| ABC-74159 | COMPLETED | Task | Sprint 208 |
| ABC-73181 | COMPLETED | Story | Sprint 208 |
| ABC-73875 | COMPLETED | Story | Sprint 208 |
I have these columns in Sprint Master Table and i am trying to claculate Total Completed.
The query i am using is :
But some how it is considering even Incompleted ones and showing result as 8.
The result is
| ISSUE_KEY | SPRINT_REPORT_STATUS | ISSUE_TYPE_NAME | WORK_UNITS_COMPLETED |
| ABC-74676 | INCOMPLETED | Task | 1 |
| ABC-74579 | COMPLETED | Story | 1 |
| ABC-74585 | COMPLETED | Story | 1 |
| ABC-74415 | COMPLETED | Task | 1 |
| ABC-74160 | COMPLETED | Task | 1 |
| ABC-74159 | COMPLETED | Task | 1 |
| ABC-73181 | COMPLETED | Story | 1 |
| ABC-73875 | COMPLETED | Story | 1 |
Help needed as why Incompleted is also considered when query is correct.
Thank you very much
No problem, Please accept my answer as a solution.
Need Power BI consultation, hire me on UpWork .
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
3 Replies
JeevanMallya
The code that you have given is DAX, not the m code in power query. To get you expected result, please try this codeWORK_UNITS_COMPLETED = IF(Sprint_Master[SPRINT_REPORT_STATUS]="COMPLETED" && (Sprint_Master[ISSUE_TYPE_NAME]="Story" || Sprint_Master[ISSUE_TYPE_NAME]="Task" ) , CALCULATE(Count(Sprint_Master[ISSUE_KEY])))Need Power BI consultation, hire me on UpWork .
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Thank you very much
No problem, Please accept my answer as a solution.
Need Power BI consultation, hire me on UpWork .
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun