Can I get calculated table in power query?

alex-JF — Thu, 28 Dec 2023 05:49:49 GMT

Hi there,

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.?

Re: Can I get calculated table in power query?

123abc — Thu, 28 Dec 2023 08:00:25 GMT

Yes, you can perform various transformations, including adding calculated columns, in the Power Query Editor in Power BI. The Power Query Editor provides a user-friendly interface for shaping, transforming, and enriching your data before it gets loaded into your Power BI data model.

Here's a brief overview of how you can add calculated columns in Power Query:

Load Data into Power Query: After importing your data into Power BI, you can launch the Power Query Editor by clicking on the "Edit Queries" button in the Home tab.
Navigate to Add Column Tab: Inside the Power Query Editor, navigate to the "Add Column" tab on the ribbon.
Choose Calculated Column: Within the "Add Column" tab, you'll find various options for adding columns. To add a calculated column, you can use the "Custom Column" option.
Create Formula: When you choose "Custom Column," a dialog box will appear where you can input your formula. Here, you can write expressions using the M language (the language behind Power Query) to create your calculated column based on existing columns in your table.
For example, if you want to create a calculated column that adds values from two existing columns (Column1 and Column2), you can use a formula like:

[Column1] + [Column2]

Apply and Close: After defining your formula, click OK. The calculated column will be added to your table in the Power Query Editor.
Additional Transformations: Apart from adding calculated columns, you can perform various other transformations such as filtering rows, sorting data, pivoting, unpivoting, merging tables, and more within the Power Query Editor.
Load Data: Once you've applied all the necessary transformations, you can click on the "Close & Apply" button to load the transformed data into your Power BI data model.

By leveraging the capabilities of the Power Query Editor, you can shape your data according to your requirements, ensuring that it's clean, structured, and ready for analysis in Power BI.

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

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.

Re: Can I get calculated table in power query?

Anonymous — Fri, 29 Dec 2023 03:15:48 GMT

Hi alex-JF ,

Sorry, If you create a calculated column or calculated table in Power BI Desktop, the table and the new column couldn't show in Power Query pane, because they are using the different engine.

For your demands, please reshape and clean the data in power query.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: Can I get calculated table in power query? in DAX Commands and Tips

Can I get calculated table in power query?

Re: Can I get calculated table in power query?

Re: Can I get calculated table in power query?