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. ...
Need Help
ibarrau's avatar
ibarrau
Icon for Super User rankSuper 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
    Icon for Super User rankSuper 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,

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks this solution worked for me since I had the same issue