"If" & "And" Power Query formula help

[Anonymous]

Hello,

I am looking to create a power query that looks at multiple columns and checks whether these all have a common value - in this case I am looking for "Complete".

Currently my query reads:

if ([Brand Completeness] = "Complete" and [#"SC Franchise Completeness "]="Complete" and [Commercial Franchise Completeness] = "Complete" and [Varient Completeness] = "Complete" and [ShelfLife Completeness] = "Complete" and [#"Medically Critical completeness"] = "Complete") then "Core Master Data complete" else "Incomplete"

I am getting results for some rows and errors for others. Any ideas? 

Thanks!! 

[amitchandak]

@Anonymous , can click on error on error row and check

Formula seems correct. Hope you have double quote in name

Try like

if [Brand Completeness] = "Complete" and [#"SC Franchise Completeness "]="Complete" and [Commercial Franchise Completeness] = "Complete" and [Varient Completeness] = "Complete" and [ShelfLife Completeness] = "Complete" and [#"Medically Critical completeness"] = "Complete" then "Core Master Data complete" else "Incomplete"

[AlB]

Hi @Anonymous 

What does the error message say exactly?

Perhaps you are comparing text ("Completed") to another data type in some cases?

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers