Forum Discussion

cajojohn's avatar
cajojohn
Frequent Visitor
3 years ago
Solved

Summarize Data with Custom Columns

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!

Tips and Tricks
Tutorial Requests
  • cajojohn's avatar
    cajojohn
    3 years ago

    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. 

     

2 Replies