Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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
Proud to be a Datanaut!
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
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
Proud to be a Datanaut!
Thank you for the 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
Thank you for the solution.
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
Proud to be a Datanaut!
@BA_Pete @wdx223_Daniel @AlexisOlson @ImkeF
Hi Top Solution Authors, your help would be much appreciated.