Extract data from PowerBI

cwayne758 not a problem, will do my best to explain what i did.

The only way to extract the data from Power BI is to copy an entire table in the fields tab. However some tables can be very large and therefore cannot be copied over easily. Within Power BI there is an option to create a formulated table within the Data screen in the desktop version (see picture)

You will then see the along the ribbon an option called New Table. The new table feature creates a table based off of DAX formula. This is where the formula I posted before comes in.

Train Report net Sum = SUMMARIZE('Train report master data', 'Train report master data'[Consignment], "Net Total", SUM('Train report master data'[Net]))

I called the table Train Report net Sum. SUMMARIZE creates a filtered table with just the DISTINCT consignmnet numbers, the "net total" is the new column I want, then the SUM('Train report master data'[Net] gives me the sum of the Net weight to the distinct count of consignment numbers.

Its only a small table as this is all the data I needed, someone else may now how to do a better one though.

Once this table was created I then right click on it in the fields tab and click copy table. Then this can be pasted into excel.

I hope this was clear, if not please let me know.

Thanks,

Giles