Created tables using DAx doesn't show in Power Query

[Anonymous]

Hello,

I have created new tables using DAX from tables in the model. I want to merge two of the new tables.When I open Power Query Transform Data, I can't see the tables I have created. I see only the tables imported from data source. 

How can I add these new tables to power query editor? If it is not possible, do you know a Dax command to do that?

Thanks in advance 🙂

[edhans · Accepted solution]

You cannot. Power Query is a one way street - from source data to the data model. Objects like calculated tables and columns do not show up in Power Query. You have two options here.

1. Create the calculated table in Power Query. You might need to use the Group By functionality on the transform ribbon, then add some custom columns. It depends what you need. Then do the merge.
2. You cannot merge in DAX, but you can bring values from one table to another in calculated columns using the LOOKUPVALUE() function, which is similar to VLOOKUP in Excel.

#2 is not recommended. If it is a small model it won't matter, but if it is large, over 1M records, you will suffer from the lack of optimized compression calculated columns has. Your best bet is to always shape your data in Power Query or earlier, and leave the DAX model to just do analysis.