Forum Discussion
JP-Ronse
Helper II
Helper IImerge 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).
MarcelBeug
Community Champion
Community ChampionDankjewel, 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/
JP-RonseHelper II
Helper IIThanks.