Power Query - True or False based on data in rows (whilst ignoring "null" values)

[MintPolo]

Hi there,

I'm trying to ascertain the number of pupils that have achieved all their grades being 7 to 9. 

For this, I want power query to look across all subjects, check if the value is 7 or greater, and if so for all subjects, return a value of "true" in a final column. 

However, not all pupils take the same subjects, and a lot of the cells will have a null value - but I don't want these null values to be considered when ascertaining if they achieved all grades 7 to 9. I want the null values ignored.

E.g.

Any help would be greatly appreciated. Thanks so much. 

[MintPolo]

Bless you Sparta. Greatly appreciated!

[SpartaBI]

@MintPolo my pleasure 🙂
P.S. Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543

[SpartaBI · Accepted solution]

@MintPolo 
Here is a link to download a sample solution file:
Power Query - True or False based on data in rows 2022-08-04.pbix

      

Showcase Report – Contoso By SpartaBI