Custom column, measure or table

Hey rayinOz ,

at first id suggest to pivot the data so your data would look like this

let
Source = #table( {"Column 1", "Column 2", "Column 3"}, { {001 ,"Course A", "Complete"}, {001 ,"Course B", "Complete"}, {002 ,"Course A", "Incomplete"}, {002 ,"Course B", "Complete"}, {003 ,"Course A", "Complete"}, {003 ,"Course B", "Complete"}, {004 ,"Course A", "Incomplete"},
{004 ,"Course B", "Incomplete"} }),
#"Pivot" = Table.Pivot(Source, List.Distinct(Source[#"Column 2"]), "Column 2", "Column 3"),
#"Renamed" = Table.RenameColumns(#"Pivot",{{"Column 1", "Id"}})
in
#"Renamed"

Now just check where "Course A" and "Course B" is Complete.