Forum Discussion
Return Specific value from a condition
Hi All, Can someone help me achieve the "Value" column based on the category from the below dataset. Let say Inscope values are A, C and E, I want to return ID's that are inscope in the "Value" c...
Thank you again for looking into this. I did expanded the Output column. The error that was occured previously about the ID wasn't found is now disappeared, I can see values in the Output column when i extract or expand the column. However, Firstly, I cannot see the data or table columns as shown in the below screenshot and is the last step in my power query applied steps and secondly, the Output column is just returning everything from the list and not filtering values based on category column.
Resource Table:
not sure what you mean by "data or table columns".
Pick the ID and Output columns and do your comparisons.