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

MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
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).