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.

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?