Can I get calculated table in power query?

[flightformee]

If I'm getting it right, I'm importing data from different sourses in power bi, in power query to be precise, then I can manipulate with tables? add calculated columns and so on. But some transformation of data can be done only in Power Query window, so is there a way to get to to power query table with calculated columns and etc.?

[Anonymous · Accepted solution]

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.