Forum Discussion
MintPolo
4 years agoFrequent Visitor
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 ...
- 4 years ago
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
MintPolo
4 years agoFrequent Visitor
Bless you Sparta. Greatly appreciated!
SpartaBI
Community Champion
4 years agoMintPolo 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