Forum Discussion
Filter out the blank values from table
Hi, Im workin on a requirement that... Requirement: From the above table i want to get the participant name who did not attempeted the test( the value for respective columns is empty). All th...
Greg_Deckler
Community Champion
Community ChampionDheeraj I would highly recommend unpivoting your columns by right-clicking on Participant column and then choosing Unpivot other columns. Then this should be fairly trivial. Otherwise, you will need to use something like MC Aggregations - https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-p/391698#M129