Forum Discussion

AndreiCapraru's avatar
AndreiCapraru
New Member
5 years ago
Solved

Reporting on pending task

Hi everyone,   I am very new to Power Bi and would appreciate a bit of help with the current dilema. I have worked my way through building a dashboard for a project task completion status, however ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    AndreiCapraru , I am hoping you need the report status in table 2.

    Create a new column

     

    new column =
    var _1 = countx(filter(Table1, Table2[ID] = Table1[ID]), Table[ID])
    var _2 = countx(filter(Table1, Table2[ID] = Table1[ID] && Table1[Status] ="COMPLETE"), Table[ID])
    var _3 = maxx(filter(Table1, Table2[ID] = Table1[ID] && Table1[Status] ="PENDING"), Table[Name])
    return
    switch(true(),
    _1=_2 , "COMPLETE",
    _1 -_2 =1 , _3 ,
    "MULTIPLE"
    )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

AndreiCapraru , I am hoping you need the report status in table 2.

Create a new column

 

new column =
var _1 = countx(filter(Table1, Table2[ID] = Table1[ID]), Table[ID])
var _2 = countx(filter(Table1, Table2[ID] = Table1[ID] && Table1[Status] ="COMPLETE"), Table[ID])
var _3 = maxx(filter(Table1, Table2[ID] = Table1[ID] && Table1[Status] ="PENDING"), Table[Name])
return
switch(true(),
_1=_2 , "COMPLETE",
_1 -_2 =1 , _3 ,
"MULTIPLE"
)

AndreiCapraru's avatar
AndreiCapraru
New Member
5 years ago

Thanks amitchandak , that worked perfectly and also learned something in the process 🙂