Multiple AND and OR combination

[jash_makadiya]

Hello Everyone..

Can anyone guide me with this.. the below underlined are column name and i want to frame a power query for the same

If "learning centred teaching = completed" AND (course design = completed OR course design for constructive = completed)  AND practicum = completed AND (at least 2 other completes from one of the remaining columns: lecturing, leading effective discussions, utc_table, assessment, scholarship) THEN TRUE, else FALSE?

Thank you in advance.

[BA_Pete · Accepted solution]

Hi @jash_makadiya ,

In Power Query if would be something like this. I'm assuming that if a field isn't completed, then it's null:

if [learning centred teaching] = "completed"
    and ([course design] = "completed" or [course design for constructive] = "completed")
    and [practicum] = "completed"
    and List.NonNullCount({[lecturing], [leading effective discussions], [utc_table], [assessment], [scholarship]}) >= 2
then "TRUE"
else "FALSE"

Pete

[BA_Pete · Accepted solution]

Hi @jash_makadiya ,

In Power Query if would be something like this. I'm assuming that if a field isn't completed, then it's null:

if [learning centred teaching] = "completed"
    and ([course design] = "completed" or [course design for constructive] = "completed")
    and [practicum] = "completed"
    and List.NonNullCount({[lecturing], [leading effective discussions], [utc_table], [assessment], [scholarship]}) >= 2
then "TRUE"
else "FALSE"

Pete

[jash_makadiya]

Thank you for the solution.

[AlexisOlson · Accepted solution]

I think @jash_makadiya is looking for "completed" rather than non-null.

Maybe change the last condition to

List.Count(
    List.Select(
        {[lecturing], [leading effective discussions], [utc_table], [assessment], [scholarship]},
        each _ = "completed"
    )
) >= 2

[jash_makadiya]

Thank you for the solution.

[BA_Pete]

That's why I said I was assuming that if a field wasn't completed it was null. A non-null count on those columns would work fine in this scenario.

Pete

[jash_makadiya]

@BA_Pete @wdx223_Daniel @AlexisOlson @ImkeF 

Hi Top Solution Authors, your help would be much appreciated.