Forum Discussion
Solved
Power Query - True or False based on data in rows (whilst ignoring "null" values)
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 ...
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
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI
Bless you Sparta. Greatly appreciated!
- SpartaBI
Community Champion
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