Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Table A | |
Subject | IEYN |
Subject 1 | Yes |
Subject 2 | Yes |
Subject 3 | Yes |
Subject 4 | Yes |
Subject 5 | No |
Table B | |
Subject | NSYN |
Subject 1 | Yes |
Subject 2 | Yes |
Subject 3 | Yes |
Subject 4 | No |
Subject 5 | Yes |
@Kiranbc , what if the issue ?
You can try like
filter(Union(TableA, TableB), [IEYN] ="Yes")
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)
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.