+ Reply to Thread
Results 1 to 7 of 7

multiple outputs from single power query

  1. #1
    Registered User
    Join Date
    08-27-2015
    Location
    kuwait
    MS-Off Ver
    Office 365
    Posts
    31

    multiple outputs from single power query

    I have a large data in excel sheet and i need few outputs in a single table through power query. iam able to generate the data using multiple queries. it would be helpful if one query can do this task. attached is excel sheet for better understanding
    Attached Files Attached Files
    Last edited by siddiqsh; 01-25-2021 at 05:49 AM.

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: multiple outputs from single power query

    Please try

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-27-2015
    Location
    kuwait
    MS-Off Ver
    Office 365
    Posts
    31

    Re: multiple outputs from single power query

    Thanks for solution and it is working well for my database.

  4. #4
    Registered User
    Join Date
    08-27-2015
    Location
    kuwait
    MS-Off Ver
    Office 365
    Posts
    31

    Re: multiple outputs from single power query

    I want to add one more column to the result. sample file attached.
    Attached Files Attached Files
    Last edited by siddiqsh; 07-16-2022 at 03:12 AM.

  5. #5
    Registered User
    Join Date
    08-27-2015
    Location
    kuwait
    MS-Off Ver
    Office 365
    Posts
    31

    Re: multiple outputs from single power query

    Quote Originally Posted by siddiqsh View Post
    I want to add one more column to the result. sample file attached.
    please look into this

  6. #6
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: multiple outputs from single power query

    try

    Please Login or Register  to view this content.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    08-27-2015
    Location
    kuwait
    MS-Off Ver
    Office 365
    Posts
    31

    Re: multiple outputs from single power query

    Quote Originally Posted by Bo_Ry View Post
    try

    Please Login or Register  to view this content.
    thanks for your support, it is working well.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Power Query - excel formula translation into Power Query
    By afgi in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-19-2020, 03:38 AM
  2. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  3. [SOLVED] Power Query - Eliminate Rows Within A Single Cell
    By bdpate09 in forum Excel General
    Replies: 4
    Last Post: 10-30-2019, 08:51 PM
  4. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  5. Multi rows into Single row using power query
    By alipezu in forum Excel General
    Replies: 4
    Last Post: 10-22-2017, 08:02 AM
  6. [SOLVED] multiple outputs for a single lookup value
    By Pavan.Sada.PS in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-04-2014, 02:37 PM
  7. Multiple outputs from single function, possible?
    By ras100 in forum Excel General
    Replies: 2
    Last Post: 02-25-2012, 02:33 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1