Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Im having a problem, I'm creating a table made from the union of several tables, i have in total 69 datafields but when i made an specific union between 2 tables the values are multiplied. i have a table called "rgs_horas_trabajadas" and the other one is called "Combinar2" both of them have the field "ProyectoId" that i use to make the union, this because i need to get a field i dont have in the table "Combinar2" and is on "rgs_horas_trabajadas". it let me do the connection but when i select the field that i want to add to my principal table the values are multiplied.
Solved! Go to Solution.
Hi @BricioJ ,
If you want to get a field you dont have in the table "Combinar2" and is on "rgs_horas_trabajadas" , you may need to use EXCEPT function instead of union.
Except function will returns the rows of the first table in the expression which do not appear in the second table.
Union function just reates a union (join) table from a pair of tables.
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @BricioJ ,
If you want to get a field you dont have in the table "Combinar2" and is on "rgs_horas_trabajadas" , you may need to use EXCEPT function instead of union.
Except function will returns the rows of the first table in the expression which do not appear in the second table.
Union function just reates a union (join) table from a pair of tables.
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |