Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

creating new table based on two table condition

There are two tables A and B and I want to merge below tables into the new one with subjects when IEYN and NSYN =yes.  The below dax which i created combining both yes and no subjects EligibleSubj...
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , what if the issue ?

 

You can try like 

 

filter(Union(TableA, TableB), [IEYN] ="Yes")

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks Amit. There are other columns in the tables so i want just the subjects of the both tables in the new table with condition [IEYN] ="Yes" (Table A) and NSYN = "Yes" (Table B)