excel power query

  1. K

    How to count "Same Purchase item Qty total" and "minus Same Sale Qty total " ??? make report

    How to count "Same Purchase item Qty total" and "minus Same Sale Qty total " if Qty balance is "0" , not show entry in report Again.
  2. G

    power query refresh time from SharePoint really slow

    How do I reduce refresh time for power query which loads data from SharePoint. I have disabled background refresh and data preview download in background. Still it's slow. Any solutions? I am loading data from am a online share point online List to excel via power query(only by creating...
  3. N

    Excel Power Query dynamically inserting rows

    Hi all, I need to dynamically insert a row into a table based on a cell value. I'm able to insert the row, but I haven't figured out how to make it dynamic. The row will always go above the row with the value "2270PBAKE" in the STAGE column. I'm using the Table.InsertRows function. For the...
  4. N

    Dynamically insert new columns in Excel Power Query and sort column pairs horizontally

    I'm stumped with a requirement and can't seem to get past it (I've tried to scour the internet, and I'm unable to fix it myself, given my lesser experience with Power Query). I could accomplish this using VBA, but the number of records, that need to be processed are shy of half a million...
  5. N

    Power Query -Data from Multiple pages

    Hi Excel 2016 -Power Query Need to understand and know How to extract multiple pages data using Power Query. Listing below two websites which has multiple pages of data https://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm...

Some videos you may like

This Week's Hot Topics