Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Power Query Help

  • 1.  Power Query Help

    Posted Aug 03, 2021 11:38 AM
    Hi,
    I have SKUs in 4 column and their corresponding quantity as shown below and I have attached my expected output that I want. Please help me how can I achieve this in power query.

    Data:-

    Output:-




    ------------------------------
    J M
    ------------------------------


  • 2.  RE: Power Query Help

    Posted Aug 03, 2021 08:30 PM
    Edited by Philippe Addelia Aug 03, 2021 08:32 PM

    Create 4 queries, 1 for each couple Label value

    Promote the first row as column header

    Create a append query

    Reduce rows starting from row1 for 1 row and with rows to keep = the number of rows till next label.



    ------------------------------
    Philippe Addelia
    Director of Business Intelligence
    Upland CA
    ------------------------------