Forum Discussion
Filter records by second column, based on primary column answer
First thing that comes to my head is this..
Duplicate the Table and remove all but columns B and E and filter it to just "Yes"Then, merge this table back to your main table using column B
Expand column E(from table 2) and rename it to make it a little more clear.
Use this new column and only filter for "Yes"
First thing that comes to my head is this..
Duplicate the Table and remove all but columns B and E and filter it to just "Yes"
Then, merge this table back to your main table using column B
Expand column E(from table 2) and rename it to make it a little more clear.
Use this new column and only filter for "Yes"
It is definitely not the best solution in terms of performance and data duplication (on the Power Query side), but it certainly worked and achieved what I needed! Right now, the raw data is about 5K records so I can live with this for now. At least I can generate the preliminary report while I find the permanent solution. You are definitely a life saver! I absolutely appretiate your help. Thanks a lot!!!