Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.