Forum Discussion
Post Partisanmissing 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)
Super Userkoorosh , 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]))
- koorosh
Why get error Amit?
FarhanAhmedCommunity Champion
cross join expect 2 inputs ,,,, you are including both columns in ALL statement... separate both columns
CrossJoin( all(Sheet1[Partner]), all(Sheet1[Course Name]))
- koorosh
The result is wrong,
In the new table "arad" should be shown with "B" and "C" course.
Hi koorosh ,
You need to add a ) after Sheet1[CourseName]
Create a Table
T2 = except(crossjoin(all('Table'[User]),all('Table'[CourseName])),selectcolumns('Table',"partner", 'Table'[User], "Course Name",'Table'[CourseName]))Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
