Forum Discussion

JP-Ronse's avatar
JP-Ronse
Icon for Helper II rankHelper 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
Icon for Community Champion rankCommunity 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
    Icon for Community Champion rankCommunity 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
      Icon for Helper II rankHelper 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
        Icon for Community Champion rankCommunity 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