Forum Discussion
koorosh
Post Partisan
Post Partisanmissing value
Hello Experts, Have a list that shows partners enrolled in courses, how to make a report that shows missed courses by each partner.
koorosh , Create new table like
New table =except(crossjoin(all(Table[partner]),all(Table[Course Name])), selectcolumns(Table,"partner", Table[partner], "Course Name",Table[Course Name]))cross join expect 2 inputs ,,,, you are including both columns in ALL statement... separate both columns
CrossJoin( all(Sheet1[Partner]), all(Sheet1[Course Name]))
HI koorosh ,
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
