Post reply

concatenating two rows into a single row

  • July 8, 2015 at 1:08 pm

    #299880

    Hi,

    I want to work with the below scenario. Looking for some help in DAX.

    1 a b

    1 a c

    2 a d

    2 a j

    I want it it be replaced with

    1 a b,c

    2 a d,j

    Can this be done using DAX in PowerPivot?

    Thank You

  • July 9, 2015 at 1:01 am

    #1811187

    Do you mean as the result of a query?

    What is your source?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • July 9, 2015 at 8:47 am

    #1811343

    I want the above result using DAX formulas in PowerPivot.

    I imported the table and I have the column as I specified above.

    Source is Oracle.

    Thank You

  • July 9, 2015 at 12:41 pm

    #1811427

    VRT (7/9/2015)

    I want the above result using DAX formulas in PowerPivot.

    I imported the table and I have the column as I specified above.

    Source is Oracle.

    What I was asking was: do you want to write a query on top of your model and return the result you wanted, or do you want to do this in the model itself?

    Inside the model is impossible, since you can't modify data inside the Power Pivot model.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • July 9, 2015 at 1:10 pm

    #1811436

    Sorry. If I didnt give proper information.

    I want to do it in the model. Not using query.

    I have seen an online link but its giving error at the final step.

    http://www.sqljason.com/2013/01/group-multiple-rows-to-single-delimited.html

    I think we can do using PowerQuery. We can also do it in PowerPivot but not easy.

    Thank You

  • July 9, 2015 at 2:17 pm

    #1811450

    VRT (7/9/2015)

    Sorry. If I didnt give proper information.

    I want to do it in the model. Not using query.

    I have seen an online link but its giving error at the final step.

    http://www.sqljason.com/2013/01/group-multiple-rows-to-single-delimited.html

    I think we can do using PowerQuery. We can also do it in PowerPivot but not easy.

    In Power Query it will probably be quite straight forward.

    In the article you linked to, they don't actually group the rows into the model. The number of rows stay the same, they just add the concatenated values to all rows. It's only in the final pivot that you get the aggregated results.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply