Forum Discussion
missing value
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)
Why get error Amit?
cross join expect 2 inputs ,,,, you are including both columns in ALL statement... separate both columns
CrossJoin( all(Sheet1[Partner]), all(Sheet1[Course Name]))
The result is wrong,
In the new table "arad" should be shown with "B" and "C" course.
Hi koorosh ,
Your Sheet1 Table in the Visualization Pane should have values from New Table.
Here in the screenshot the values are selectd from the sheet1 table.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)Thanks to all gentlemen, Amit, Farhan, Harsh.
In the main table (sheet1) arad enrolled in "A" and "D" course. In the new table, we are looking for missed courses for arad!
- New_Table = EXCEPT(CROSSJOIN(all(Sheet1[Course Name]),all(Sheet1[Partner])),SELECTCOLUMNS(Sheet1,"partenr",Sheet1[Partner],"course",Sheet1[Course Name]))