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.
Good morning community, again I turn to your help, if anyone can help me:
You have 3 tables, the 3 tables were created from a mother table that had everything together in columns; I separated them using DAX;
These 3 tables in DAX have a column in common that is called "ID", You need to join these 3 tables based on this common "ID" expecting as a result the following in a single table to the left
IMPORTANT: I do not use the option to join tables that has power query, because the tables were created with DAX and power query does not read them; must necessarily be with dax
Solved! Go to Solution.
@Syndicate_Admin you can write this two measures and it will return the fully joined table
_Ren_Rendimiento = MAX(rendimiento[Ren_Rendimiento])
_ut_Utilizacion = MAX(utilizacion[ut_Utilizacion])
Hi @Syndicate_Admin ,
According to your description, here's my solution.
Create a new table.
Table =
ADDCOLUMNS (
'Disp',
"Ren_Rendimiento", MAX ( 'Ren'[Ren_Rendimiento] ),
"ut_Utilizacion", MAX ( 'Ut'[ut_Utilizacion] )
)
Get the expected result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Syndicate_Admin you can write this two measures and it will return the fully joined table
_Ren_Rendimiento = MAX(rendimiento[Ren_Rendimiento])
_ut_Utilizacion = MAX(utilizacion[ut_Utilizacion])
Hi,
You said that you already have a mother table. Then why are you joining the 3 tables again into a consolidated table?
it was joined vertically, I broke it down and I need to join it horizontally
Hi,
Try using the Pivot feature in the Query Editor.
It does not work for me, as I indicate in problem, the tables are created in DAX, and when running the powerquery the tables are not visible
I also use a result of this type: that based on the ID the complete tables are added to the left; any of the options serves me; but it must be in dax
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 |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |