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
SpartaBI
Community Champion
Community ChampionMintPolo
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