Forum Discussion
Solved
merge rows
Hi, A bookkeeping application generates an export that looks as: What I need is: Is this possible? Kind regards, JP-Ronse
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).
Dag Marcel,
Can you recommend some reading to get more familiar with PQ?
Prettig eindejaarsfeest.
JP-Ronse
Dankjewel, insgelijks. (Thanks, likewise)
With regard to readings: sometimes I publish video's about specific Power Query subjects on my YouTube channel and I recently published a Power Query (M) Functions dashboard.
Otherwise you can find learning resources on http://www.thebiccountant.com/learning-resources/
Thanks.