Forum Discussion
JP-Ronse
8 years agoHelper II
merge rows
Hi, A bookkeeping application generates an export that looks as: What I need is: Is this possible? Kind regards, JP-Ronse
- 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
8 years agoCommunity Champion
MarcelBeug
8 years agoCommunity Champion
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).