Using Power Query to summarise stock balances at all locations

**josephteh** · 07-22-2020, 09:31 PM

I have a list of stocks at various locations and would like to summarise them by all location using Power Query.

Appreciate your help. Thank you in advance.

Joseph

PQ Summarise Stock Balances.png

**Bo_Ry** · 07-23-2020, 01:26 AM

Please try

Please Login or Register  to view this content.

**josephteh** · 07-23-2020, 03:52 AM

Thank you, Bo_Ry! Worked perfectly!

Using Power Query to summarise stock balances at all locations

LinkBack

Thread Tools

Rate This Thread

Display

Using Power Query to summarise stock balances at all locations

Re: Using Power Query to summarise stock balances at all locations

Re: Using Power Query to summarise stock balances at all locations

Thread Information

Users Browsing this Thread

Similar Threads

Power Query to download historical stock data from Yahoo Finance

[SOLVED] Conditional remove duplicates based on another column in power query related to (power bi)

[SOLVED] Power Query - excel formula translation into Power Query

[SOLVED] How to add an Excel formula code into Power Query or create a new one in Power Query

[SOLVED] Power Pivot does not load new column added in Power query

Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)

Modifications in Power Query not updating in Power BI Service linked via Local Drive Excel

Bookmarks

Bookmarks

Posting Permissions