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 ...
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.

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