Forum Discussion

Mesh's avatar
Mesh
Frequent Visitor
6 years ago

Merge Query does not carry over new columns created

I am trying to merge two tables in PowerBI desktop. One of the tables has a number of new columns that I created, but when I merge the tables, the new columns are not present in the merged dataset.

 

Is there any way I can include the new columns in the merged table?

Need Help

4 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    6 years ago

    Hi. Can you be more specific about how are you creating columns and merging data? What I can suspect is that you are creating the columns in DAX that runs after the PowerQuery code runs (merging). If you want the columns in the merge be sure to add custom column in power query (transform data or edit query menu).

     

    Hope this helps, if not, please detail more the problem.

    Regards,

    • Mesh's avatar
      Mesh
      Frequent Visitor
      6 years ago

      Yes I am - is there no way to get the DAX columns to carry over?

       

      If not, what's the easiest way to transfer the columns from DAX to power query?

      • ibarrau's avatar
        ibarrau
        Super User
        6 years ago

        There is no way to see DAX columns in Power Query. The engine runs step by step, imagine the model is created with power query and DAX create things when the model is created.

         

        The way to go is Adding a Custom Column in Power Query that will let you write code. That way if you have conditions, you can replicate them. We can help you if you show the DAX code (unless it is a crazy 20 lines business code hahaha)

         

        Regards,