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).

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

    • MarcelBeug's avatar
      MarcelBeug
      Community Champion
      8 years ago

      Luckily you still have the recommended Power Query solution. :manwink:

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

        Dag Marcel,

         

        Can you recommend some reading to get more familiar with PQ?

         

        Prettig eindejaarsfeest.

         

        JP-Ronse