Summarize Data with Custom Columns

[cajojohn]

Hello, 

I have a table in Power BI from which I need to export the data into a txt file. I am doing so using power automate.

I have been able to use summarizecolumns to appropriately extract the original table data. However, I am needing to add in some custom columns into the export.

I have found that summarizecolumns does not allow custom columns. Is there another way to add in custom columns to the data export?

I have included the Query that is currently pulling data below, without the custom column Projects[Value] and Projects[Level02Code] added. I need to add a custom column to this query. The flow continues to fail when these custom columns are added. 

Current Working Query

Thanks!

[Anonymous]

Hi @cajojohn ,

You can add a calcualted column in Power BI Desktop using DAX or addd a custom column in Power Query using M language.

How to Add a Calculated Column in Microsoft Power BI | TechRepublic

Add a custom column (Power Query) - Microsoft Support

If you want to export data, please refer to

Export data from a Power BI visualization - Power BI | Microsoft Learn

3 Ways For Exporting Data From Power BI: A Complete Guide - Learn | Hevo (hevodata.com)

Exporting Data from Power BI Desktop to Excel and CSV – Part 1: Copy & Paste and DAX Studio Methods ...

Best Regards,

Stephen Tao

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

[cajojohn · Accepted solution]

I believe I found a solution, but would be interested to see if there is another way.

Instead of using a custom column in the exsisting Projects table, I created a custom table and added the new columns this way. This let me use summarizecolumns with all of the columns in the new table.