Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Transform table with Pivot Table, DAX formula

  1. #1
    Board Regular
    Join Date
    Oct 2011
    Posts
    232
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Transform table with Pivot Table, DAX formula


    Transform table with Pivot Table, DAX formula
    Hello to all,

    I'm new with Pivot Tables, DAX formulas and I want to know if it is possible to get the output desired with PT, Power Pivot, DAX etc.

    I'm using Excel 2016.

    This is my input Table:

    DESCRIPTION VALUE
    STAGE 1
    ID 0
    NAME JFMSC
    TYPE MLRR
    DFRUL P1
    ADDR 1001
    RRUL P1
    SPRR TRUE
    ISGALW FALSE
    ISUTWD FALSE
    STAGE 1
    ID 2
    NAME PLLSJS
    TYPE MLRR
    DFRUL P1
    STAGE 1
    ID 4
    NAME AAAARR
    TYPE MLRR
    DFRUL R2
    ADDR 3553
    RRUL P1
    SPRR FALSE
    ISGALW FALSE
    ISUTWD FALSE
    ADDR 66444
    RRUL P1
    SPRR FALSE
    ISGALW FALSE
    ISUTWD FALSE
    ADDR 890087
    RRUL P1
    SPRR FALSE
    ISGALW FALSE
    ISUTWD FALSE
    STAGE 1
    ID 0
    NAME PPROOA
    TYPE RRHN
    DFRUL P1
    ADDR 7034
    RRUL P1
    SPRR FALSE
    ISGALW FALSE
    ISUTWD FALSE


    And this is the output I'd like to obtain:

    STAGE ID NAME TYPE DFRUL ADDR RRUL
    1 0 JFMSC MLRR P1 1001 P1
    1 2 PLLSJS MLRR P1
    1 4 AAAARR MLRR R2 3553 P1
    66444 P1
    890087 P1
    1 0 PPROOA RRHN P1 7034 P1

    Is possible or only with VBA macro?

    Thanks in advance

  2. #2
    Board Regular
    Join Date
    Aug 2012
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Transform table with Pivot Table, DAX formula


  3. #3
    Board Regular
    Join Date
    Oct 2011
    Posts
    232
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Transform table with Pivot Table, DAX formula

    Quote Originally Posted by brawnystaff View Post
    Thanks for your answer. I tried to do the example in the liks you shared and is not working.

    If you know about Power Query, may you give me the steps more in detail please.

  4. #4
    Board Regular
    Join Date
    Aug 2012
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Transform table with Pivot Table, DAX formula

    Your right, that example was not as good..

    Was able to find a better one at URL below, but only deals with one column vs. your two..

    https://www.mrexcel.com/forum/power-...vals-data.html

  5. #5
    Board Regular
    Join Date
    Oct 2011
    Posts
    232
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Transform table with Pivot Table, DAX formula

    Thanks so much for the links shared. Have helped me.

    Best regards

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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