Multiple AND and OR combination

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

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