Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to filter ID;s based on another column

Hi, I have a table where there is ID, previoustasks_ttaskids and employee_ttaskresourceid columns. I need to filter the table to contain only the ID's where previoustask_ttaskid = id and display the ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    This calculated column formula works

    Column = LOOKUPVALUE('refResourceTask (2)'[employee_ttaskresourceid],'refResourceTask (2)'[id],'refResourceTask (2)'[previoustasks_ttaskids])

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Seanan . These ID:s actually describes employee positions. Id is the position id, previous task id's are telling that is a superior for the  particular position etc. So there is a superior-employee hierargy represented and the employee_ttaskresourceid is the person who holds the position

 

This is a bit tricky as this hierargy is not represented in any other form. For example nowhere in the db there is no clear indicator who is a superior and who is not and I need to report employee work leaves by the superior etc.

 

here is a sample pic from dev. environment what this data represents

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Seanan Hi, and thanks for your effort to help with this case. Ashis provided workable suggestion and I resolved the case.