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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 - BI Insight [8291-9787-8c5-6bcf]

                                                                                                                                                         

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.