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

     

     

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

You said that you already have a mother table.  Then why are you joining the 3 tables again into a consolidated table?

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

    it was joined vertically, I broke it down and I need to join it horizontally

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      4 years ago

      Hi,

      Try using the Pivot feature in the Query Editor.

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

        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