Forum Discussion

nareshupadhyay's avatar
nareshupadhyay
Frequent Visitor
4 years ago
Solved

Get the data based on another column

Hi Team

 

I am new in Power BI and working on report. I got stuck at point and need your help.

 

I have below mention coulumns in a table. in this table, I have Parent task e.g., Test_Timesheets and same has TFSIDTask 67890.

Under this task, we have chield task e.g., Parent TFS task and same has TFSIDTask as well. Every task has taskID and it's task ID will ParentTaskID for chield task. 

Now, I need to create another column which shows Parent TFSIDTask for chield. Can someone please help me get Parent TFSIDTask for Chield?

 

Thanks 

Naresh

Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, nareshupadhyay 

     

    Try to create a column like this:

    Column = LOOKUPVALUE([TFSIDTask],[TaskId],[ParentTaskId])

    Result:

    Please refer to the attachment below for details. Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    4 years ago

    Hi, nareshupadhyay 

     

    Try to create a column like this:

    Column = LOOKUPVALUE([TFSIDTask],[TaskId],[ParentTaskId])

    Result:

    Please refer to the attachment below for details. Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • xander2121's avatar
    xander2121
    Frequent Visitor
    4 years ago

    Hello Naresh,

     

    I am not able to understand your question. Can you explain it a bit more?

  • nareshupadhyay's avatar
    nareshupadhyay
    Frequent Visitor
    4 years ago

    Hi,

    I need to get parent TFSIDTask in another Column for its chield. e.g., TFSIDTask 67890 is parent for 23456 and 12345 then I would like to have 67890 in another column infront of 23456 and 12345.

     

    Thanks

    Naresh