Can I get calculated table in power query?

Hi  flightformee ,

Do you mean that the calculation tables created using dax cannot be displayed in Power Query?

This is due to the design of Power BI, the tables and columns we create with Dax will not show up in Power Query because Power Query operations are based on the datamodel and use the M language.

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 can consider the following approach:

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.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.