Forum Discussion

JP-Ronse's avatar
JP-Ronse
Helper II
8 years ago
Solved

merge rows

Hi,   A bookkeeping application generates an export that looks as:     What I need is:     Is this possible?   Kind regards,   JP-Ronse
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    8 years ago

    Conceptually, queries shape unstructured data into tables. Next, DAX (and visuals) may kick in for further data analysis, like aggregation and (filter) context sensitive calculations.

     

    So, in this specific case, I would recommend a Power Query solution, even though it can also be done with DAX (in combination with visuals).

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

HI JP-Ronse

 

Try this.

 

First Use the Query Editor to fill down the Blank Cells

 

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

JP-Ronse

 

Now you can use this MEASURE to concatenate the HEAD 2

 

Head_2 Measure =
IF (
    HASONEVALUE ( Table1[Head_1] ),
    CONCATENATEX ( Table1, Table1[Head_2], " " )
)
  • JP-Ronse's avatar
    JP-Ronse
    Helper II
    8 years ago

    Hi Zubair_Muhammad,

     

    Thanks for the swift reply! I am a learning newby with a long way to go (I'm afraid). Can you explain how to add a Measure?

     

    Kind regards,

     

    JP-Ronse

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      8 years ago

      JP-Ronse

       

      You can add it from the Modelling Tab or by right clicking the Table fields

      The picture below shows this

       

      • JP-Ronse's avatar
        JP-Ronse
        Helper II
        8 years ago

        Hi Zubair_Muhammad,

         

        I am using excel 2013 with the Power Query add-in and I don't find this option. I tried with a custom column but it doen't accept the formula. Maybe it is just not possible with my configuration.

         

        Kind regards,

         

        JP-Ronse