Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Join 3 tables with DAX

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...
  • smpa01's avatar
    smpa01
    4 years ago

    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])

     

     

     

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

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.