Merge Query does not carry over new columns created

[Mesh]

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?

[ibarrau]

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]

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]

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,

[salman_ali]

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